Extract AutoCAD XYZ coordinates

I am trying to extract (and separate into 3 columns) the numbers only, positive or negative portion of (XYZ) Coordinates copied from AutoCAD and pasted into column A
X = 96179.9699 Y = 61973.9793 Z = 1368.0025
In column B,C and D, I have tried to use Find Mid and other means

Please Login or Register  to view this content.

but because of the varied length of the coordinates eg:
X = 0.0207 Y = 0.0000 Z = 0.0000
I get bad returns such as 0.0207 Y

Also, I need the number to include the hyphen in any negative coordinate.

Thanks in advance for any help you can give.

X: =mid(a1, search("x", a1) + 3, search("y", a1) - search("X", a1) - 3) + 0

y: =mid(a1, search("y", a1) + 3, search("z", a1) - search("y", a1) - 3) + 0

z: =mid(a1, search("z", a1) + 3, 255) + 0

er you are in row 2 so adjust formula to reflect that a2 not a1
also change format of cells to number 4 decimal places