Dear Expert,
I want to get few specific words from a cell like cell a1= "George Ladies OPP Jogger #WBTPF-1056/1473/74/75 Balance (9500)".
I want to get from a1 to a2 "Ladies OPP Jogger" .
Here my first word is 1st word 'George" & Last word which word contain "#".
SO i need of these middle all words.
Please help me to get this formula.
Best Regards
Wahid
Try:
Please Login or Register to view this content.
Quang PT
Dear Expert,Originally Posted by bebo021999
Try:
Please Login or Register to view this content.
Your formula is working accordingly. thanks for that. But here i would not fixed first word "George", any time it may change like "Morrison", "Dunnes" and other.
So what will my formula in this regards?
Please help me.
Try this:
Please Login or Register to view this content.
❖ Please mark your thread is SOLVED if there has been offered a solution that works fine for you.
❖ If you like solutions provided by anyone, feel free to add reputation by clicking on ✶ Add Reputation bottom left of their posts.
Small change to your formula:Try this:
Please Login or Register to view this content.
Formula:
Please Login or Register to view this content.
or
Formula:Please Login or Register to view this content.
to remove space after last word.
Last edited by Tommy90; 05-14-2020 at 07:07 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks