software

Hi.
I think it's going to be difficult to satisfy my requests.
Anyway, I have a list of symbols in column A like the following:
00001 = xxx (it refers to...)
00305 = ysu (it refers to...)
01203 = ghst (it refers to...)
04506 = bkse (it refers to...)
12340 = fist (it refers to...)
....

Does anyone know if there're any function which can do the following:

1)
I would like to take the (number) symbol out to column B.
Any redundant quot;0quot; has to be removed (eg 00001 --gt; 1; 01203 --gt; 1203).

2)
I would like to take the text symbol out to column C (eg xxx, ysu, ghst)3)
Finally, the description to column D.
Remove the brackets.
Remove the phrase quot;it refers toquot;.

As a note, it's best if it can be done by a function as the list is frequently
updated.
Thank you!

=============
Windows XP
Office XP
Assume the list starts in A2, in B2

=--LEFT(A2,FIND(quot; quot;,A2)-1)

copy down

in C2

=TRIM(MID(LEFT(A2,FIND(quot;(quot;,A2)-1),FIND(quot;=quot;,A2) 1,255))

copy down

in

D2

=TRIM(SUBSTITUTE(MID(A2,FIND(quot;(quot;,A2) 13,255),quot;)quot;,quot; quot;))

copy down--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;0-0 Wai Wai ^-^quot; gt; wrote in message
...
gt;
gt; Hi.
gt; I think it's going to be difficult to satisfy my requests.
gt; Anyway, I have a list of symbols in column A like the following:
gt; 00001 = xxx (it refers to...)
gt; 00305 = ysu (it refers to...)
gt; 01203 = ghst (it refers to...)
gt; 04506 = bkse (it refers to...)
gt; 12340 = fist (it refers to...)
gt; ...
gt;
gt; Does anyone know if there're any function which can do the following:
gt;
gt; 1)
gt; I would like to take the (number) symbol out to column B.
gt; Any redundant quot;0quot; has to be removed (eg 00001 --gt; 1; 01203 --gt; 1203).
gt;
gt; 2)
gt; I would like to take the text symbol out to column C (eg xxx, ysu, ghst)
gt;
gt;
gt; 3)
gt; Finally, the description to column D.
gt; Remove the brackets.
gt; Remove the phrase quot;it refers toquot;.
gt;
gt; As a note, it's best if it can be done by a function as the list is
gt; frequently
gt; updated.
gt; Thank you!
gt;
gt; =============
gt; Windows XP
gt; Office XP
gt;
gt;

gt; Assume the list starts in A2, in B2
gt;
gt; =--LEFT(A2,FIND(quot; quot;,A2)-1)
gt;
gt; copy down

WoW! It works like a charm.
However I couldn't figure out why it works.
I understand you use quot;FIND(quot; quot;,A2)-1quot; to locate the position of space.
But why does it work to remove extra quot;0quot;?
It seems to do with the 2 magic quot;minusquot;.

(I still figuring out the rest of your codes!
I'll have another reply soon.)

Best

gt; Assume the list starts in A2, in B2
gt;
gt; =--LEFT(A2,FIND(quot; quot;,A2)-1)
gt;
gt; copy down

WoW! It works like a charm.
However I couldn't figure out why it works.
I understand you use quot;FIND(quot; quot;,A2)-1quot; to locate the position of space.
But why does it work to remove extra quot;0quot;?
It seems to do with the 2 magic quot;minusquot;.

(I still figuring out the rest of your codes!
I'll have another reply soon.)

Best