One lateral idea to approach this, which might work fine here

Assume you have a checklist of "standard" bank names in D1:D10, eg:
Bank of America
Bank of India
St George Bank
etc

Assume your embedded data viz.:
Bank of America LTD Inc, US1234567-001
is running in A1 down

Place in B1, normal ENTER:
=INDEX(D$1:D$10,MATCH(TRUE,INDEX(ISNUMBER(SEARCH($ D$1:$D$10,A1)),),0))
Copy down. Col B will return the required "standard" bank names
corresponding to the names embedded in col A.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"Ranjit kurian" wrote:
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