Why does REDUCE Function gives VALUE Error

So I am trying to extract the cities from the string, though I have resolved the issue, with an alternative formula, but my reason to ask this query, is that, I was earlier trying to use the REDUCE()...