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()...
Sir I'm using MS 365 latest version with Beta channel enabled. Version 2209 Build 15619.20000
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