View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
HammerD HammerD is offline
external usenet poster
 
Posts: 6
Default Extract text on right of various length from cells

I have a list of cells with a "number" & description (i.e. - 260 SMALL
THINGS, 261 THINGS).
I want to just capture the text (of varying lengths) from the three digit
numbers.
I am making another column for just the numbers with the formula
"=LEFT(C1,3)" - but how can I capture just text?

Thanks in advance...