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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks