I hope there is a better way but I think this should work. Select the
two columns. Go to the 'data' tab and then "text to columns". By
selecting delimiters you should convert your data from two columns to 8
columns. Then for the 9th column you enter the formula
=A1+B1/60+C1/3600. You can add the "W" if you want which should be D1.
You do similarly with Latitude so the 10th column is =E1+F1/60+G1/3600
and again you can add the N if you need to.

Note: I think you have your formula wrong....it is degrees, minutes,
seconds so the degrees are correct as is and you divide the seconds by
3600 not the other way around.


--
camjohnson
------------------------------------------------------------------------
camjohnson's Profile: http://www.excelforum.com/member.php...o&userid=33751
View this thread: http://www.excelforum.com/showthread...hreadid=535280