Hi, is there anyway i can extract the data into as per PIC?
Attachment 586335
Hi, is there anyway i can extract the data into as per PIC?
Attachment 586335
The first red arrow points to "trendy" the others to "jewelery"
So are you trying to extract "trendy" as well as "jewelery" ?
In order to extract the word "jewelery" a pattern must be searched for.
You cant search for a pattern with one piece of data, supply some more data please.
Not saying I'll solve this by the way.
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.
Extract by the number and separating each number. i.e [1] , [2] , [3]
To separate column E by number:
Enter formula in cell F2 and drag formula across to H2
Formula:Please Login or Register to view this content.
Please see attached file
Last edited by AlKey; 08-15-2018 at 09:08 AM.
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)
Bookmarks