Results 1 to 20 of 20

How to remove #'s 0-9 and spaces

Threaded View

elite-fusion How to remove #'s 0-9 and... 04-17-2011, 03:56 AM
pike Re: How to remove #'s 0-9 and... 04-17-2011, 04:35 AM
pike Re: How to remove #'s 0-9 and... 04-17-2011, 07:40 AM
martindwilson Re: How to remove #'s 0-9 and... 04-17-2011, 10:03 AM
Charlie_Howell Re: How to remove #'s 0-9 and... 04-17-2011, 01:21 PM
Marcol Re: How to remove #'s 0-9 and... 04-17-2011, 01:50 PM
elite-fusion Re: How to remove #'s 0-9 and... 04-17-2011, 04:33 PM
Charlie_Howell Re: How to remove #'s 0-9 and... 04-17-2011, 02:45 PM
Charlie_Howell Re: How to remove #'s 0-9 and... 04-17-2011, 06:03 PM
martindwilson Re: How to remove #'s 0-9 and... 04-17-2011, 06:46 PM
elite-fusion Re: How to remove #'s 0-9 and... 04-17-2011, 07:02 PM
martindwilson Re: How to remove #'s 0-9 and... 04-17-2011, 07:08 PM
elite-fusion Re: How to remove #'s 0-9 and... 04-18-2011, 12:43 AM
elite-fusion Re: How to remove #'s 0-9 and... 04-18-2011, 01:28 AM
LMinGA Re: How to remove #'s 0-9 and... 04-18-2011, 04:48 PM
Marcol Re: How to remove #'s 0-9 and... 04-17-2011, 07:14 PM
elite-fusion Re: How to remove #'s 0-9 and... 04-18-2011, 12:38 AM
pike Re: How to remove #'s 0-9 and... 04-18-2011, 02:43 AM
martindwilson Re: How to remove #'s 0-9 and... 04-18-2011, 03:46 AM
elite-fusion Re: How to remove #'s 0-9 and... 04-18-2011, 04:43 PM
  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