Hi all,
Thanks a lot for welcoming me again. Need your help in solving my problem i tried a lot to solve this but unsuccessful and still trying.
For eg: This is the text and i want to extract only the nos but not to add. Levis Mens 501 straight Jeans (6901163478597_00501-1937_32W x 34L_Dark Indigo)
The answer will be 6901163478597_00501-1937_32 meaans without the text.
Request you to kindly help me.
Appreciate you help in advance
Ronita
In orde ro do this properly we need to find a pattern.
You can't find a pattern with one piece of data.
Have you any other examples?
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
if you have your data in A1 try below formula
=LEFT(MID(A1,FIND("(",A1)+1,9^9),MIN(INDEX(SEARCH(MID("abcdefghijklmnopqrstuvwxyz",ROW($1:$26),1),MID(A1,FIND("(",A1)+1,9^9)&"abcdefghijklmnopqrstuvwxyz")-1,0)))
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Or this array formula
=SUBSTITUTE(LEFT(A1,SMALL(IFERROR(FIND(CHAR(ROW(A$65:A$90)),A1,1),""),1)-1),"(","")
***Array formula must be entered by using key combination of CTRL+SHIFT+ENTER and not just ENTER
Row\Col (6901163478597_00501-1937_32W x 34L_Dark Indigo) 6901163478597_00501-1937_32
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks