LinkBack URL
About LinkBacks
=TRIM(MID(SUBSTITUTE($A1,"#",REPT(" ",LEN($A1))),(COLUMNS($B1:B1)-1)*LEN($A1)+1,LEN($A1)))
IF YOU HAVE YOU DATA IN CELL A1 TRY ABOVE FORMULA
Edit the range as per your need
=TRIM(MID(SUBSTITUTE($A1,"#",REPT(" ",LEN($A1))),(COLUMNS($B1:B1)-1)*LEN($A1)+1,LEN($A1)))
IF YOU HAVE YOU DATA IN CELL A1 TRY ABOVE FORMULA
Edit the range as per your need
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks