insert spaces between numbers in column

[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

 

[Frank Kabel]

Hi
if this is stored as number you may apply the following custom format
to these cells (goto 'Format - Cells')
00 00 00

 

[Trevor Shuttleworth]

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

 

[jvolson]

first post, problem solved in 10 minutes.

thanks for the help .. worked perfectly