Thread: remove numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ranjit kurian Ranjit kurian is offline
external usenet poster
 
Posts: 83
Default remove numbers

I need a excel function to remove the numbers, decimals, coma, semicolon and
words like "LTD", "INC" from the cells.

The name in the cells are not fixed, it keep changes

example :
my cell ("A1") contain the below details
Bank of America LTD Inc, US1234567-001.

the excel function should give the below answer
Bank of America