View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Access Joe Access Joe is offline
external usenet poster
 
Posts: 54
Default How to extract just text from cells

Hi all,

I want to extract only TEXT from a column of numbers and text. For example:

WHAT I HAVE:
150mgdl
2000mg
10mgdl
500cc

WHAT I WANT:
mgdl
mg
mgdl
cc

is there a function in Excel that does this and extracts only the text, not
the numbers?

Thanks everyone!