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()...
Okay, but you said an error is on Excel Desktop and you don't use Excel for web
Ok Sir, I found out, that I can use REDUCE() Function anywhere, i.e. I have used that specific formula in other workbooks and as well as in new workbook as well, but it is not working for this specific texts strings. For those US Addresses