Later versions of Excel has a new compatibilty version for handling unicode characters in the formula calculation.
This is set via a extLst element in the workbook xml:
<ext xmlns:xlwcv="http://schemas.microsoft.com/office/spreadsheetml/2024/workbookCompatibilityVersion" uri="{D14903EA-33C4-47F7-8F05-3474C54BE107}">
<xlwcv:version setVersion="2"/>
</ext>This affects the calculation of the LEN, MID, FIND, SEARCH and REPLACE functions.
See the Office documentation
Later versions of Excel has a new compatibilty version for handling unicode characters in the formula calculation.
This is set via a extLst element in the workbook xml:
This affects the calculation of the LEN, MID, FIND, SEARCH and REPLACE functions.
See the Office documentation