LinkBack URL
About LinkBacks
Try this one, no helper columns is required
=CONVERT(LEFT(A2,FIND("'",A2)-1)*12+SUBSTITUTE(MID(A2,FIND("'",A2)+1,9),"""",),"in","m")
Try this one, no helper columns is required
=CONVERT(LEFT(A2,FIND("'",A2)-1)*12+SUBSTITUTE(MID(A2,FIND("'",A2)+1,9),"""",),"in","m")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks