Thread: Removing Digits
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Faraz A. Qureshi Faraz A. Qureshi is offline
external usenet poster
 
Posts: 211
Default Removing Digits

Any formula to convert entries like

123AAA456BBB
AA12BB4567CCC

to:

AAABBB
AABBCCC

i.e. simply removing the digits 0-9 from the entry?

Thanx in advance!

--
Best Regards,

Faraz