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.


--
Aoife101
------------------------------------------------------------------------
Aoife101's Profile: http://www.excelforum.com/member.php...o&userid=35928
View this thread: http://www.excelforum.com/showthread...hreadid=557231

Extracting Data
 

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)

Aoife101 Wrote:
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.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=557231

Extracting Data
 

That worked thanks so much! :)


--
Aoife101
------------------------------------------------------------------------
Aoife101's Profile: http://www.excelforum.com/member.php...o&userid=35928
View this thread: http://www.excelforum.com/showthread...hreadid=557231