Thread: Modifying Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TimH TimH is offline
external usenet poster
 
Posts: 9
Default Modifying Data

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