Extracting numbers (Coordinates) from string

[kratk]

Hi:

How can i leave only the coordinates and supress the text from the string next string:

Command: ID Specify point: X = 5068.7648 Y = 224.3896 Z = -4063.3161

When i copy this from the AutoCad, it copies it the whole text only in the first cell (A1 for example)
This is for a large list of points (exactly as the showed above)..... So i need, basicly, to convert the data pasted in one cell to the next format:

Xvalue Yvalue Zvalue.

At the moment i'm using the TextToColumn tool and manually deleting the columns that i don't need but is extremely slow..... so thats i'm asking for your valuable help.

Thank A lot

 

[tushiroda]

copy into the formula bar for the cell in excel and not into the cell directly. check to see the "=" is in there at the front too. Noone else can reproduce your problem so not sure what else to tell you...