Exell question

1. How did you get the data in ??ÿ If you import you can specify comma or tab delimited data and excel will automatically seperated the data for you .?ÿ

2. At this point though you can select all the data and use the "Text to Column" wizard under the Data Tab. Use Fixed width and click next, you will see your data in a window with vertical lines seperating it out. I would click between?ÿ the rest of the data to seperate everything into its own column that way the point number is on its own, the equal sign, the coordinate and so on. you can also tell excel to skip columns too when using the wizard so the only thing you end up with is point number, X and Y values.?ÿ?ÿ

Try highlighting (selecting) column A. Go to the 'data' header in the ribbon and then 'text to columns'.

It should open the dialog that @gary_g described above. You'll have to play with the parameters but, it is a strong and effective tool.

@gary_g ?ÿ Old school I love it. As technical a smart phone and app savvy ?ÿas the younger folks are i mean I learn something new every day from one of my crew chiefs he shows me some all that does all sorts of tricks. But excel throws him for a loop lol. I had to teach him a few tricks today. He laughed and said only old people use this but wow I never knew you could do that.

-- attachment is not available --

?ÿ

Hello, I would like the data from cell 2 to be separated them in columns?

For instance in one column to be the A1 second column x1=520... data and the third column Y1=391...

How this can be done?

What I would do is open the original text file in Notepad then use search and replace to put commas where you want the column breaks and removing extra spaces at the same time. Change the extension to CSV then double-click to open it in Excel.

For example:

A1,X1=,520136.964,Y1=,3912463.269

It is best to make a copy of the original and edit the copy. That way if editing goes sideways itƒ??s easy to start over on a new copy.

?ÿ

@dave-karoly get Text ++ or notepad plus I canƒ??t remember the exact name. Its like notepad on steroids. One of those you can assign numbers to rows just like excel has and do a lot so copying commas vertical down a sheet between information. Geezers it stinks getting older and not using that stuff recently. Your way works but if you like notepad that text plus was awesome and has the ability to do some xml language as well. Back 20 years ago it was my go to when i was combining multiple data sets for database entry from surveying data and gis data then we would import into excel and save as a db4 format. I donƒ??t even know if dbf4 is even a option now days. Lol. I did use excel and text plus a lot though especially getting data from so many different locations. I used it when I got out of the usmc in 2005. Every one would give there crews a point file of point number,northing,East.elevation,code. But all the elevation when not needed was 0 so people in the field complaining about the robot looking into the earth when they said turn to. It was a cad thing-999999999 or 0. Anyway I would find and replace like you until i had 0.00 on a northing or easting that would cause the office managers that clicked through to fast and such. So i showed how much easier at that time it was to use text plus to fix before going to the field collector. It might not exist anymore who knows. This thread reminded me if it.

Text ++ or notepad plus I canƒ??t remember the exact name. Its like notepad on steroids.

I'm pretty sure you mean notepad++.

Really nice editor.?ÿ I found it sometime in the late 90s when we changed over to windows.

?ÿ

@bobwesterman lol has it really been that long. 90ƒ??s. Geezers. I remember going from dos to windows and back to dos and windows lol. Then unix. Which was the best if all. I be processing 24 hour files of static data for absolute point position. And processing a traverse running a gis buffer and it would never miss a beat. It was not always fast but it never crashed or locked up.

I like to ditch Excel as often as possible - too easy to forget itƒ??s not always the best tool.

Notepad++ definitely offers a few excellent ways to solve your problem here, but the ability to use ƒ??regex,ƒ? or ƒ??regular expressionsƒ? with Notepad++ƒ??s find-and-replace utility is what should be easiest (otherwise Iƒ??m a fan of using ƒ??Block Selectƒ?, see https://m.youtube.com/watch?v=6T6B3c3dPFI )

Follow?ÿ@dave-karolyƒ??s advice and save a backup copy (also easy to do with Notepad++, although beware that the ƒ??Save a Copy Asƒ? is not the same as ƒ??Save Asƒ?). My advice would be to remove all the X1ƒ??s and Y1ƒ??s and the equals signs, and insert a comma before your horizontal coordinates.

To do this, bring up Notepad++ƒ??s find-and-replace utility by pressing Ctrl+h

Toggle ƒ??Regular expressionsƒ? in the lower left corner of the utilityƒ??s window. Then type in the following into the ƒ??Find whatƒ? field:

?ÿX[0-9]+=
(I included a space before the X)

In the ƒ??Replace withƒ? field, type:

,?ÿ

(I included a space after the comma).

Since you have a backup copy, just try ƒ??Replace Allƒ? and see what happens - if you messed something up, hit undo

So now you should have A1, 5000000,Y1=2000000

Now change your ƒ??Find whatƒ? field to:

Y[0-9]+=

and delete everything in the ƒ??Replace withƒ? field.

Hit ƒ??Replace Allƒ? and save the updated copy.

You should have

A1, 500000, 200000

ƒ??