Hi, Karan,
Not a good one, but try this Array Formula,
If you are using XL 2003 or prior,
=MAX(IF(ISNUMBER(MID(SUBSTITUTE(A2,"
",""),ROW(INDIRECT("1:"&LEN(A2))),{6,7})+0),MID(SUBSTITUTE(A2,"
",""),ROW(INDIRECT("1:"&LEN(A2))),{6,7})+0))
If you are on XL 2007 or later,
=MAX(IFERROR(MID(SUBSTIT
check the below mentioned linked
regards
sanjib
http://office.microsoft.com/en-us/excel-help/extracting-numbers-from-alphanumeric-strings-HA001154901.aspx
On Fri, Oct 7, 2011 at 11:37 AM, karan 1237 wrote:
> Dear All,
>
> Hope you all are doing well !
>
> I need your assistance to sort out my
