Thank you very much for your response. Just as a note every time I see
'Garry"s Student,it cracks me up - what an absolutely fabulous pen name.

"Gary''s Student" wrote:

=MID(A1,6,2)
--
Gary''s Student - gsnu200753


"Finance Guru" wrote:

Hello,

I am running excel 2003. Can somebody please help.

I have 2 columns
Row A B
1 1525-FE-Clientname FE
2 2799-HE-Clientname HE
3
4


Colum A data is selected from a dropdown list.( of which there are about 300
items in the list ) I would like to have a Lookup Function that checks out
the 6+7 character of the column A entry and put the result into Colum B.
Presently I have to type in the data into column B based on the result of the
entry in Column A.

Any assistance would be appreciated.