At 05:20 22/11/2020 -0700, Gilles Noname wrote:
Brian Barker wroteIf 00°05'12"O 42°59'12"N is in A1, then =(MID(A1,12,2)+(MID(A1,15,2)+MID(A1,18,2)/60)/60)*((RIGHT(A1,1)="N")*2-1) will deliver 42.9866666667, and =(LEFT(A1,2)+(MID(A1,4,2)+MID(A1,7,2)/60)/60)*((MID(A1,10,1)="E")*2-1) will deliver -0.0866666667.I tried this formula, but get error 509 ("operator expected"). Maybe it's because the cell contains "Numbers"?
No, that's not what error 509 means.
You've shown us the error message, but with focus on a different cell, not showing the error. So no-one can see the erroneous formula! I'm guessing that your locale needs semicolons as separators in place of the commas.