I have this copy in cell A1.
https://www.test.org/sample/text/
I'm struggling to extract only "text" from this string.
Can anybody help please?
I have this copy in cell A1.
https://www.test.org/sample/text/
I'm struggling to extract only "text" from this string.
Can anybody help please?
Your link is broken. Try
Please Login or Register to view this content.
It's a dummy link, not real.
I should've stated, I need a formula for this, not a VBA solution.
You probably should post a sample workbook with examples of what you have and the results you want. It only Hass to be 15 to 20 rows. See the instructions in the yellow banner at the top of the post.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Try this:
=TRIM(RIGHT(SUBSTITUTE(A1,"/",REPT(" ",99)),198))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Please try,
=TRIM(MID(SUBSTITUTE(A1,"/",REPT(" ",LEN(A1))),LEN(A1)*(LEN(A1)-LEN(SUBSTITUTE(A1,"/",""))-1),LEN(A1)))
Regards
My English is very poor, so please be patient >_<"
My Dynamic Related Dropdown post:
https://www.excelforum.com/excel-for...ml#post5657376
https://www.excelforum.com/excel-for...ml#post5655711
https://www.excelforum.com/excel-for...ml#post5655762
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks