Quote Originally Posted by mahmoud-lee View Post
Thank you mr admin , This formula is not working after the seventh condition
Define a Name via Name Manager

Select the first cell in your range (here I selected A2 on Sheet1)

Name: String

Refers to:
PHP Code:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Sheet1!$A2,1,""),2,""),3,""),4,""),5,""),6,""),7,"") 
In B2:

=TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(String,8,"" ),9,""),0,""))

Note: The dollar sign should be there berore the column name.