I have Excel spreadsheets that have a single column containing the following "typical" GPS cell data.

N34 27.576 , W82 34.857

In order for another program to extract this info and work, I need to modify my spreadsheet so that I have TWO columns and not one.

#1 Column = N34 27.576

#2 Column = W82 34.857

Any chance your know how to do this by using a formula..?

Paul at kankula@bellsouth.net