I have a workbook with several formulas like the following one:
My problem is that when opening the excel file from a system using a different locale - and more specifically different list separators (";" instead of ",") the commas insidePlease Login or Register to view this content.
are not converted, since they are considered as strings. All the other commas, however, are converted, so the formula results in #REF! error.Please Login or Register to view this content.
How could I get excel to treat those "," as list separators, and thus convert them too to ";"? Is there some sort of generic reference to list separator, which I could use instead of the comma inside those strings?
Bookmarks