Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =IFERROR(TRIM(MID(C3, FIND(":",C3) + 1, FIND(":",C3,FIND(":",C3)+1) - FIND(":",C3) - 1)),"")
- =IFERROR(LEFT(C3, FIND("-",C3,1)-1),"")
- =IFERROR(TRIM(RIGHT(C3,LEN(C3) - FIND("-", C3, FIND("-", C3) + 1))),"")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement