Formula:Extracting Data

Hey all

If I have a column with a list of reference codes such as:

Ab101
Ne444
Af876
Ne254
Sd345
Sd654

Is there any formula that will allow me to extract the letters eg. Ab, Ne etc. into the following column??
Any suggestions would be great.

if you have data in the same format then use the following function.
if your data starts from A1 put in B1
=MID(A1,1,2)

Originally Posted by Aoife101

Hey all

If I have a column with a list of reference codes such as:

Ab101
Ne444
Af876
Ne254
Sd345
Sd654

Is there any formula that will allow me to extract the letters eg. Ab, Ne etc. into the following column??
Any suggestions would be great.

That worked thanks so much!