<div>
Unless I misunderstand your intent, wouldn't a Find and Replace do what you need? &nbsp;Just search for all 0s and leave the Replace field blank. &nbsp;Then search for all 1s and so forth. &nbsp;You could even record a basic macro to do this with one swoop.<br />
<br />
As long as your search requirements don't include the whole field, this should work.<br />
<br />
If I don't fully understand your need, let us know.
</div>


Unless I misunderstand your intent, wouldn't a Find and Replace do what you need?  Just search for all 0s and leave the Replace field blank.  Then search for all 1s and so forth.  You could even record a basic macro to do this with one swoop.

As long as your search requirements don't include the whole field, this should work.

If I don't fully understand your need, let us know.

Book1.xls

<div>
<div class="content wysiwyg-content">
I need to remove all numbers from an excel spreadsheet <br />
<br />
I have tried some different vba formulas but none of them work- it ends up just removing 1 number from the cell when I want to remove all numbers.<br />
<br />
Any suggestions that would be easier than creating a formula in vba?
</div>
</div>


I need to remove all numbers from an excel spreadsheet 

I have tried some different vba formulas but none of them work- it ends up just removing 1 number from the cell when I want to remove all numbers.

Any suggestions that would be easier than creating a formula in vba?

Remove all numbers from excel cells in worksheet

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.