Extracting Data

A

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.
 
S

starguy

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)
 
Top