View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Isa
 
Posts: n/a
Default Select only the letters from a cell

Hi,

I have a list of values which include letters and numbers:

ADP45
DSVC54
DEPT25 etc....
In the next column I want to only see the letters without the numbers:
ADP
DSVC
DEPT

Is there a function to do this?

Thanks.

Isa.