Hello all,
I have the following data in a cell:
55°66'77.88"N122°33'44.55"W
I need to be able to change it to this:
55°66'77.88"N,122°33'44.55"W
(All GPS coords have Ns and Ws only).
So, if it finds the letter 'N', then insert a comma after it.
Same would apply for a cell with the following data in it:
12.345678°-123.456789°
The above should be displayed like this:
12.345678°,-123.456789°
Haven't been able to find the correct formula.
The closest one I have found so far is this:
=REPLACE(B2,FIND("N",B2),0,",")
But, I'm not replacing anything with anything, AND, it places a comma BEFORE the 'N' instead of AFTER it.
Thank you in advance.
--Nelson.
Bookmarks