LinkBack URL
About LinkBacks
Hi All,
I would like to return the text between the 4th and 5th slash, in this case "Category". What would the exact formula be? (cannot use text to columns or PQ).
http://example.com/database/Category...ct/CODE002.jpg
Appreciate your help, thanks!
Hi All,
I would like to return the text between the 4th and 5th slash, in this case "Category". What would the exact formula be? (cannot use text to columns or PQ).
http://example.com/database/Category...ct/CODE002.jpg
Appreciate your help, thanks!
Try...
Formula:
Please Login or Register to view this content.
Adjust 99, as needed.
Edit:
Alternately... you can substitute 4th & 5th "/" with character that does not occur in the string. And use FIND to locate position.
And then supply that to MID() function to extract.
Formula:Please Login or Register to view this content.
Last edited by CK76; 11-23-2018 at 10:14 AM.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Thanks CK76, that worked great. What does 99 mean in this context?
Basically, formula is replacing each "/" with 99 spaces. Since it is large enough number, it will create enough buffer between each character.
99*4 will fall somewhere in spaces before "Category" and 99 length will fall somewhere after.
You can see intermediate step, by just using =SUBSTITUTE(A1,"/",REPT(" ",99)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks