Extract code which is number and text.

[visha_1984]

Hi,

little formula will help me out
i just trying to extract code which contain number and text

FOREXP - A V ENTERPRISES PQVMS139

OUTPUT - PQVMS139


Attached sample file.

[skywriter]

You can try this in B2 and then copy down.

Please Login or Register  to view this content.

[visha_1984]

You can try this in B2 and then copy down.

Please Login or Register  to view this content.

Perfect Thanks

[AlKey]

Here is shorter way with an array formula

=TRIM(MID(A2,MATCH(1,-MID(A2,ROW(A$1:A$99),1))-7,9))

***Array formula must be entered by using key combination of CTRL+SHIFT+ENTER and not just ENTER