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()...
I have no errors if open the file in my locale
Perhaps you have another list separator, e.g. semicolon instead of comma
No Sir, I use comma only. You can see the .gif it is not working, if you open the excel workbook then on sheet 2 also i created some random text where it is not working, very strange and weird
Are you on Excel Desktop or Excel for Web? If the latest, which regional settings do you use?
If you open the file attached to the previous post do you have errors? I have no ones in both sheets.
- Sir its not working both places Excel Desktop as well as in Web. Sir workbook is editable mode
If your own file, try to re-enter formula (F2->Enter)