EXTRACT NUMERIC FROM A ALPHANUMERIC TEXT
HELP ME PLEASE TO EXTRACT NUMERIC FROM A ALPHANUMERIC TEXT LIKE AB1234C, 123 NO, A123B456 ETC
ExcelExperts.com
Excel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832
ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 1481 guests online.
New Excel Experts
Current Excel / VBA Jobs |
EXTRACT NUMERIC FROM A ALPHANUMERIC TEXTHELP ME PLEASE TO EXTRACT NUMERIC FROM A ALPHANUMERIC TEXT LIKE AB1234C, 123 NO, A123B456 ETC |
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
Remove Non Numeric Characters
this is what you're looking for:
http://excelexperts.com/Excel-Tips-Remove-Non-Numeric-Characters
EXTRACT NUMERIC FROM A ALPHANUMERIC TEXT
Sir your process is too lenghty and unworkable for my program. I want a simple formula to get this.
Regards
Anil
you can limit the amount of
you can limit the amount of calculations it does if you know what the non-numeric symbols will be...
for example, if you know that only A and B are in the string, you can use:
=SUBSTITUTE(SUBSTITUTE("A12B3A","A",""),"B","")
=>
123