LinkBack URL
About LinkBacks
Assuming you start the formulas in row 2 with row 1 being headers, you could use
=SUBSTITUTE(INDEX(A:A,2*ROW()-3),"Pin:","")
=SUBSTITUTE(INDEX(A:A,2*ROW()-2),"User ","")
Assuming you start the formulas in row 2 with row 1 being headers, you could use
=SUBSTITUTE(INDEX(A:A,2*ROW()-3),"Pin:","")
=SUBSTITUTE(INDEX(A:A,2*ROW()-2),"User ","")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks