ExcelBanter - Removing text from Alphanumeric values

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Removing text from Alphanumeric values (https://www.excelbanter.com/excel-worksheet-functions/183248-removing-text-alphanumeric-values.html)

Syed Rizvi

Removing text from Alphanumeric values

Hi
I have a column containing alphanumeric values e.g.
HG06100
H134679
HC134679
HG05534
A434340
I need a formula or macro help to remove all the text values in the cell and
leave all the numbers behind including zero. Could someone please help, thanks

Syed

Dave Peterson

Removing text from Alphanumeric values

Check one of your several other posts.

Syed Rizvi wrote:

Hi
I have a column containing alphanumeric values e.g.
HG06100
H134679
HC134679
HG05534
A434340
I need a formula or macro help to remove all the text values in the cell and
leave all the numbers behind including zero. Could someone please help, thanks

Syed

--

Dave Peterson

All times are GMT +1. The time now is 02:02 AM.