Hi

I have W2K with Excel2K

I have a worksheet that links to another file.

In cell A2 the link returns the following value: PAINT-CLEAR EPOXY
PRIME-EE00155-A
In cell B2 the link returns the following value: PAINT-STOCKADE-FN22615-T


I have a helper column (H2 & H3) that allows me to remove the PAINT- from
the above values

H2 returns the value CLEAR EPOXY PRIME-EE00155-A (using =MID(A2,7,40)
H3 returns the value STOCKADE-FN22615-T (using =MID(A3,7,40)

Now what I would like to do 2 more things.

Remove the hyphen from the text from the above values and have the Name in
one column and the associated serial number in another. Is this possible? If
the number of letters were the same in each instance I am sure it would be
quite simple but as the names vary in length I have no idea on how to
accomodate this?

John