Extract Middle Character

[AAP]

Hi,
I am uploading an excel file. I would like to extract middle character but couldn't figure out how. In the file First column is input and Second column is output required. Can anyone help me by using formulas or vba.

Thanks

Kind Regards
AAP

 

[NARAYANK991]

Hi ,

See the attached file ; all of them may not be correct.

Narayan

 

[AAP]

Hi ,

See the attached file ; all of them may not be correct.

Narayan

You are Great!
Many many thanks.

 

[shrivallabha]

Probably, you are looking Model Numbers.

To extract the last group before large number of spaces are occurring you can also use below construct.
=TRIM(RIGHT(SUBSTITUTE(TRIM(LEFT(A2,FIND(" ",A2&" ",1)))," ",REPT(" ",99)),99))

Edit: Forum board is eating extra spaces in the formula. Refer attached file.