Assuming all are same format. You did say "6+7"

=MID(A1,6,2) in B1 and copied down.


Gord Dibben MS Excel MVP


On Tue, 6 Nov 2007 11:56:03 -0800, 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.