Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
to extract numeric figures in left side od the alpha charectors pl
Hai all
I have an excel sheet with the following structure Code 123445PPSS4 4567ITEM 23444MALR 234555HJYT45 IN THE ABOVE EXAMPLE PLEASE HELP TO EXTRACT NUMERIC FIGURES FROM THE LEFT SIDE OF THE TEXT THE RESULT SHOULD BE 12344 4567 23444 234555 PLEASE HELP WITH THANKS AND REGARDS POL |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
to extract numeric figures in left side od the alpha charectors pl
Try
=LOOKUP(6.022*10^23,--MID(A2,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"012345 6789")),ROW(INDIRECT("1:"&LEN(A2))))) Mike "pol" wrote: Hai all I have an excel sheet with the following structure Code 123445PPSS4 4567ITEM 23444MALR 234555HJYT45 IN THE ABOVE EXAMPLE PLEASE HELP TO EXTRACT NUMERIC FIGURES FROM THE LEFT SIDE OF THE TEXT THE RESULT SHOULD BE 12344 4567 23444 234555 PLEASE HELP WITH THANKS AND REGARDS POL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to make left side stay still and right side can move left to r | Excel Discussion (Misc queries) | |||
only extract numeric value from alpha numeric cell | Excel Discussion (Misc queries) | |||
sorting alpha numeric list by first left digit | New Users to Excel | |||
Extract Numbers from Alpha-Numeric String | Excel Worksheet Functions | |||
The colums changed from alpha to numeric how do you make it alpha | Excel Discussion (Misc queries) |