try =mid(a1,6,2) and copy it down as many rows as you need.

Good luck

Ken
Norfolk, Va

On Nov 6, 2:56 pm, 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.