To Rick,
James original post example showed the ID could have any number of
hyphens before the string ID.

Hmm! So it did (I just went back and looked). Other than not noticing that,
I stayed away from the "ID" string, especially in upper or lower case (using
SEARCH instead of FIND), out of a worry that those letters could be located
in the text, as part of a larger word, in front of the ID text. I guess if
they are always upper case, the likelihood of them being in the text before
the actual ID is lessened. So, here is my formula modified to look for ID
(always upper case) instead of the dash...

=MID(A1,FIND("ID",A1),8)

I went with James latest post saying that the ID (letters plus following
numbers) was always 8 characters long.

--
Rick (MVP - Excel)


"OssieMac" wrote in message
...
yHi James,

Did you try the formulas that I posted. The look for the characters ID
wherever they are in the string.

To Rick,
James original post example showed the ID could have any number of hyphens
before the string ID.


--
Regards,

OssieMac


"James" wrote:

I don't know if I mention this also or not at the beginning but the
ID could be anywhere in the field/cell, at the end or the begining.
The only thing that will stay the same is ID with numbers will be 8
characters and each side will be dash to saperate from the rest of the
information. Right now we only find it if it is a partuclar place.