| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Text from Alphanumeric values | Excel Discussion (Misc queries) | |||
| VLOOKUP with numeric and alphanumeric values | Excel Discussion (Misc queries) | |||
| Need to test for alphanumeric value and write numeric values to ce | Excel Worksheet Functions | |||
| Generate alphanumeric unique 4 digit values from 12 digit values | Excel Worksheet Functions | |||
| how do i enter alphanumeric values? | Excel Discussion (Misc queries) | |||
Linear Mode
