LinkBack URL
About LinkBacks
Something I learnt from one of the gurus here, I think it's called.. padding with spaces and trim? Anyhoo, formulas something like this.
Formula:
=TRIM(LEFT(SUBSTITUTE($A$1,"/",REPT(" ",1000),3),1000))
Something I learnt from one of the gurus here, I think it's called.. padding with spaces and trim? Anyhoo, formulas something like this.
Formula:=TRIM(LEFT(SUBSTITUTE($A$1,"/",REPT(" ",1000),3),1000))
Last edited by quekbc; 09-02-2015 at 08:04 PM. Reason: Edit following Pete_UK's advice, re-edited after OPs post
I think you need to keep the "/" in there, so replace "/" with "/" plus a load of spaces.
Pete
no, everything AFTER the third...
OK, you need to make up your mind lol...do you want the string BEFORE the 3rd / or AFTER the 3rd /Originally Posted by djbetterly
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks