Splitting large numbers into groups (LATITUDE AND LONGITUDE)

Hi

I am having a problem. I have a spreadsheet with a column of Longitude values like:

A
172828.383E

I want to somehow split the cell into new individual cells so it will be like this:

A B C
17 28 28.383

Any tips?

Thanks in advance

formula in B1

=Left(A1,2)

Formula in C1:

=Mid(A1,3,2)

Formula in D1:

=Mid(A1,5,6)

Then you can copy those down

Then Copy the 3 new Columns, go to A1 and go to Edit|Paste Special and select Values.

If you actually want those to be actual numbers (not text strings) so that you can do further functions with them

then add a -- infront of the the Left() or MID() functions...

e.g. =--Left(A1,2)

No problem.

Can you please remember to mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save