Hello guys,
Have a spreadsheet, want to automatically do a PROPER command and a SUBSTITUTE command in order to make it look "proper" first and then remove all numbers 0 to 9 and also all spaces.
so far I have
=PROPER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"1",""),"2",""),"3",""),"4",""),"5",""),"6",""),"7",""),"8",""),"9",""),"0","")," ",""))
But it does not work, Excel says too many levels of nesting.
Any idea how i can automatically PROPER and remove all numbers and spaces? (and for future reference any particular characters besides #'s or other characters)
Bookmarks