question

T

Tiffany

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

Paul B

Tiffany, use a helper column, with your data in column A put this in column
B and copy down, =LEFT(A1,3) you can then copy that column and paste
special, valves to change the formulas to just valves.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Top