Thanks everyone for the input.
Using regexes, I split the latitudes and longitudes so they're in their own
columns.
Brian Barker wrote
> I'm guessing that "O" means "east" (as in "ouest"?) and that the
> alternatives to "O" and
> "N" are "E" and "S" respectively?
Sorry, I didn't pay attention to that part.
O = ouest = West
E = est = East
Brian Barker wrote
> If 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"?
https://postimg.cc/w764P7Rm <https://postimg.cc/w764P7Rm>
--
Sent from:
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
