I've got the following formula to extract a substring before the hyphen character (-) from cell A2:
=LEFT(A2, SEARCH("-",A2)-1)
extract-text-before-char.png
-If I enter the same formula and text string as shown in the picture above in Google Sheets, it works fine as expected.
-If I enter the same formula in Excel file where Office 365 is installed on my work computer, it works fine as well.
*Error: If I enter the same formula where Office 365 is installed on my personal computer, I'm getting a warning message as shown in the picture below:
ghjgh.png
As you may see in my formula, the highlighted cell A2 is not recognized by Excel.
P.S.
If I try to enter a simple formula like '=SUM(A3+A4)', it works as expected.
I'm only getting errors by entering more complex formulas like:
=RIGHT(A2,LEN(A2)-SEARCH("-",A2))
=MID(A2, SEARCH("-",A2) + 1, SEARCH("-",A2,SEARCH("-",A2)+1) - SEARCH("-",A2) - 1)
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B3,"color_new",C3),"color_old",D3),"level",A3)
Does anyone know the reason of this issue?
Thanks in advance!
Bookmarks