Forum Discussion
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()...
It may seem arbitrary but what does this formula return for you when placed in B1?
=REDUCE(A1,TEXT({",",".","-"},";;"),LAMBDA(x,y,SUBSTITUTE(x,y,"")))
Sir, it removes all those characters from a string