Modifying Data

[TimH]

I am trying to import a data file but edit how it looks. Here is the original
data:

ACT:990 POINT FA(PNT_144)
X=8.2207 Y=-0.9689 Z=0.2303
ACT:991 POINT FA(PNT_145)
X=8.2207 Y=-0.9702 Z=1.3993
ACT:992 POINT FA(PNT_146)
X=4.0937 Y=-0.9612 Z=1.3264
ACT:993 POINT FA(PNT_147)
X=4.0940 Y=-0.9608 Z=0.2135
ACT:994 POINT FA(PNT_148)
X=-0.5363 Y=-0.9822 Z=0.1765
ACT:995 POINT FA(PNT_149)
X=-0.5363 Y=-0.9819 Z=1.4171
ACT:996 POINT FA(PNT_150)
X=0.2498 Y=-0.1904 Z=1.4173
ACT:997 POINT FA(PNT_151)
X=0.2498 Y=-0.1898 Z=0.1923
ACT:998 POINT FA(PNT_152)
X=0.6993 Y=-0.2144 Z=0.1923
ACT:999 POINT FA(PNT_153)
X=0.7003 Y=-0.2149 Z=1.3645

I can get it to looking like this:

X=0.2498 Y=-0.1904 Z=1.4173
X=0.2498 Y=-0.1898 Z=0.1923
X=-0.5363 Y=-0.9822 Z=0.1765
X=-0.5363 Y=-0.9819 Z=1.4171
X=0.6993 Y=-0.2144 Z=0.1923
X=0.7003 Y=-0.2149 Z=1.3645
X=4.0937 Y=-0.9612 Z=1.3264
X=4.0940 Y=-0.9608 Z=0.2135
X=8.2207 Y=-0.9689 Z=0.2303
X=8.2207 Y=-0.9702 Z=1.3993


I want to get rid of the x= y= and z=

I know there is a way to do this but I am new at Excel. Any help would be
appreciated. If a macro could be wrote to start with the first file would be
best.


Thanks

 

[Pecoflyer]

Hi,

maybe Ctrl+H
replace what x=
with (nothing)

I am trying to import a data file but edit how it looks. Here is the
original
data:

ACT:990 POINT FA(PNT_144)
X=8.2207 Y=-0.9689 Z=0.2303
ACT:991 POINT FA(PNT_145)
X=8.2207 Y=-0.9702 Z=1.3993
ACT:992 POINT FA(PNT_146)
X=4.0937 Y=-0.9612 Z=1.3264
ACT:993 POINT FA(PNT_147)
X=4.0940 Y=-0.9608 Z=0.2135
ACT:994 POINT FA(PNT_148)
X=-0.5363 Y=-0.9822 Z=0.1765
ACT:995 POINT FA(PNT_149)
X=-0.5363 Y=-0.9819 Z=1.4171
ACT:996 POINT FA(PNT_150)
X=0.2498 Y=-0.1904 Z=1.4173
ACT:997 POINT FA(PNT_151)
X=0.2498 Y=-0.1898 Z=0.1923
ACT:998 POINT FA(PNT_152)
X=0.6993 Y=-0.2144 Z=0.1923
ACT:999 POINT FA(PNT_153)
X=0.7003 Y=-0.2149 Z=1.3645

I can get it to looking like this:

X=0.2498 Y=-0.1904 Z=1.4173
X=0.2498 Y=-0.1898 Z=0.1923
X=-0.5363 Y=-0.9822 Z=0.1765
X=-0.5363 Y=-0.9819 Z=1.4171
X=0.6993 Y=-0.2144 Z=0.1923
X=0.7003 Y=-0.2149 Z=1.3645
X=4.0937 Y=-0.9612 Z=1.3264
X=4.0940 Y=-0.9608 Z=0.2135
X=8.2207 Y=-0.9689 Z=0.2303
X=8.2207 Y=-0.9702 Z=1.3993


I want to get rid of the x= y= and z=

I know there is a way to do this but I am new at Excel. Any help would
be
appreciated. If a macro could be wrote to start with the first file
would be
best.


Thanks

 

[JR Hester]

If you have X, Y and Z in separate cells as it appears you do, maybe formula
along the lines of
=right(A2, len(a2)-2, "n/a")
will work for you
Presuming A2 is where the first X= statement resides

HTH