Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Modifying Data
Hi, maybe Ctrl+H replace what x= with (nothing) TimH;340949 Wrote: 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 Cheers - ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=95350 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Modifying Data
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 "TimH" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Holding company: Automatically modifying data on different workshe | Excel Worksheet Functions | |||
Modifying data in excel containing 4000+ formulas | Excel Worksheet Functions | |||
Modifying data | Excel Discussion (Misc queries) | |||
Stop Insert Row modifying formula data | Excel Discussion (Misc queries) | |||
help Modifying | Excel Worksheet Functions |