Thread: question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tiffany Tiffany is offline
external usenet poster
 
Posts: 53
Default question

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.