Results 1 to 20 of 20

How to remove #'s 0-9 and spaces

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-02-2010
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    103

    How to remove #'s 0-9 and spaces

    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)
    Last edited by elite-fusion; 04-18-2011 at 03:03 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1