View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Connie Martin Connie Martin is offline
external usenet poster
 
Posts: 251
Default Copy only letters, not numbers

I have a huge long column of text---product codes, to be exact, that could
look something like this: CNUB275X3 or PB24X275. What I need is a formula,
which I will put in the column beside this one, that will look at the code
and put only the letters up to the first number. So, in this case it would
put CNUB in the first row's cell and then PB for the next one. Is this
possible? Connie