CODES.xlsxI need help extracting from a cell, a code that is formed from letters and numbers. For example:
SOFT CASE SAMSUNG EXTRASLIM SMGR4F FOR SAMSUNG GALAXY S4
I need a formula to extract "SMGR4F"
HARD BACK CASE SVDBCASE0043 IPHONE4/4S FOR IPHONE 3
I need extracted "SVDBCASE0043"
NOTE: It is always the first word that contains text+number
I attached a document with a part of the codes, and bebo021999's formula, which works for most of the codes.
I really hope you can help me with this,
Thank you and best regards!
Bookmarks