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.