LinkBack URL
About LinkBacks
Maybe:
=TRIM(SUBSTITUTE(SUBSTITUTE(LEFT(SUBSTITUTE(MID(C1,FIND("-",C1),LEN(C1)),"-",""),FIND("/",SUBSTITUTE(MID(C1,FIND("-",C1),LEN(C1)),"-",""))-3),CHAR(10),""),CHAR(13),""))
Regards, TMS
Maybe:
=TRIM(SUBSTITUTE(SUBSTITUTE(LEFT(SUBSTITUTE(MID(C1,FIND("-",C1),LEN(C1)),"-",""),FIND("/",SUBSTITUTE(MID(C1,FIND("-",C1),LEN(C1)),"-",""))-3),CHAR(10),""),CHAR(13),""))
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Justin, this did bring back the SiteName and the date. I could then do a LEFT function in the next column and extract it that way!
TMS, looks like the Trim formula did the trick! It brought back only the SiteName.
WOW, I would have never figured that out. Thank you both for your quick replies!
You're welcome.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks