Thanks. I tried this one but did not work. I got "#value". Any
suggestions? Thank you again.

"Gary''s Student" wrote:

=LEFT(RIGHT(A1,LEN(A1)-FIND("ID",A1,1)+1),FIND("
",RIGHT(A1,LEN(A1)-FIND("ID",A1,1)),1))

--
Gary''s Student - gsnu200902