Hey,
I'd like to make a custom separator that would separate link in two part, one part before, and the other after ".html"
How do I create a formula like that ? I see that when using separators I can only use one letter or 1 digit... and I can't seem to find an option to separate text using anything else.
Help would be much appreciated!
Cheers,
vemix
=MID(a1,1,FIND(".html",B5)-1)
=MID(a1,FIND(".html",B5),50)
Help appreciated, but I don't find it to work. Why B5 anyways ?
Can you show us an before/ after example?
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks