LinkBack URL
About LinkBacks
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.
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.
You can try this in B2 and then copy down.
=IFERROR(TRIM(MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&1234567890))-6,9)),TRIM(MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&1234567890))-5,9)))
Originally Posted by skywriter
You can try this in B2 and then copy down.
=IFERROR(TRIM(MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&1234567890))-6,9)),TRIM(MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&1234567890))-5,9)))
Perfect Thanks
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
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks