Macro to delete alpha and alpha numeric values

**vijanand1279** · 01-20-2011, 07:04 AM

I am looking for a macro to delete any Alpha and Alpha Numeric cell values in a column.
Below is the sample data and desired result I am looking for. Please help

Column A Desired Result
9 9
22 22
24 24
31 31
1212USA20103
USA2865
USA
USA5494
ABCD
USA7505

**DonkeyOte** · 01-20-2011, 07:31 AM

Assuming the numbers are indeed stored as numbers (and not numbers stored as text)

Please Login or Register  to view this content.

the same could be achieved using F5 natively.

(we assume above values are constants and not result of formulae - adapt as nec.)

**Wizz** · 01-20-2011, 07:37 AM

Hi,
Try:

Please Login or Register  to view this content.

**DonkeyOte** · 01-20-2011, 07:40 AM

@Wizz, FWIW, when using SpecialCells it's always worth adding a handler.
For ex. were you to run your routine and then re-run immediately you would generate a Debug as no cells would be found (they were cleared first time around).

**vijanand1279** · 01-20-2011, 09:09 AM

Originally Posted by Wizz

Hi,
Try:

Please Login or Register  to view this content.

When I run the macro above in the attached file it clears all the values because the Format of column is in text. Even If I change the format to number Zero decimals it is not working. Please help See attached....

**DonkeyOte** · 01-20-2011, 09:13 AM

You must coerce beforehand:

Please Login or Register  to view this content.

Macro to delete alpha and alpha numeric values

LinkBack

Thread Tools

Rate This Thread

Display

Macro to delete alpha and alpha numeric values

Re: Macro to delete alpha and alpha numeric values

Re: Macro to delete alpha and alpha numeric values

Re: Macro to delete alpha and alpha numeric values

Re: Macro to delete alpha and alpha numeric values

Re: Macro to delete alpha and alpha numeric values

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions