assume AMC123 is in A1

in B1

=Left(A1,3)

drag fill down the column.

--
Regards,
Tom Ogilvy


"Tiffany" wrote in message
...
Hi

I have a column that contains all the reference no. e..g

AMC123
MOC234
CCD123

How to separate the the first 3 letters from the rest. I want to create a
column that just contains the first 3 letters.

Kindly help.