insert spaces between numbers in column

  • Thread starter Thread starter jvolson
  • Start date Start date
J

jvolson

I'm using a GIS program to enter latitude/longitude data and found
program that will automate the process (47,000 records!!). My lat/lon
data is in this format now:

593600

and i need it to be

59 36 00

still in one column. Similarly, the longitude data looks like this

1795949

and needs to be

179 59 49


How can I do this? Any help would be greatly appreciated.

Joh
 
Hi
if this is stored as number you may apply the following custom format
to these cells (goto 'Format - Cells')
00 00 00
 
You'll need to add a couple of columns. Assuming the data starts in column
A1, add this formula in the first column:

=LEFT(A1,2)&" "&MID(A1,3,2)&" "&RIGHT(A1,2)

Drag down ... Copy and Paste Special | Values over the new data. Overwrite
the original if you wish.

I'll leave you to work out the second column

Regards

Trevor
 
Back
Top