Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
separating alpha numeric vlue
Hi all,
how do separate alpha numeric value for example I have values like ABC123,AB234 starts with alpha but the length may be 2 or 3 or 4. just I want alpha value in one column and numeric in another column. could anyone help me ? thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Separating Numerical and Alpha Data in cells | Excel Discussion (Misc queries) | |||
Alpha Numeric tab not showing only numeric. | Excel Worksheet Functions | |||
only extract numeric value from alpha numeric cell | Excel Discussion (Misc queries) | |||
+1, Alpha *and* Numeric | Excel Worksheet Functions | |||
The colums changed from alpha to numeric how do you make it alpha | Excel Discussion (Misc queries) |