Excel

Excel

by Bedford Apr 20, 2007 11:41PM PDT

I am looking for a short cut in editing cells in Excel. I import coordinates from a mapping program called MapSource which puts both Longitude Latitude or in this case Easting and Northing in the same cell. The numbers are six digits, one space and then seven digits all in the one cell. I need to put these numbers in separate cells to import them to another mapping software. What I am doing now is ?copy paste? these numbers to a second cell and then deleting the seven numbers ?Northing? from the original cell and then deleting the six numbers ?Easting? from the copied cell which ends up with them separated. I need to do thousands of these in about 150 column at a time. ?I NEED TO FIND A SHORT CUT? Help Please.

Discussion is locked

- Collapse -

Re: Excel formula's

by Kees Bakker Apr 21, 2007 12:15AM PDT

If I were you, I'd use Excel character functions like left and right.

For example: left("ABCDE",2) = "AB".
Try what happens if you put '1234567 987654 in A1 and =right(a1,6) in B1.

It's rather elementary to use formulas and functions in Excel. May I recommend you do some study of those subjects? There are tutorials and books to help you with that.

Hope this helps.

Kees

- Collapse -

Wow ...that's a painful and slow way to do that

by VAPCMD Apr 21, 2007 8:29AM PDT

Believe you could also use the "Data" and "Text to Column" feature to split the cell data into two columns.

Give it a try...let us know.

VAPCMD

- Collapse -

Works great

by Bedford Apr 21, 2007 9:22AM PDT

The "Data" and "Text to Column" feature works great. I usually had data 20 to 30 columns long so the few mouse click would take care of it, but now with thousands to do, this will helps immensely. Thank You.
Regards Bedford

- Collapse -

Good to hear and Thanks for letting us know !

by VAPCMD Apr 21, 2007 10:19AM PDT

Now what are you gonna do with all the time you saved ?

VAPCMD

CNET Forums

Other Forums

Forum Info