Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =JOIN(replace(A1, find("|", SUBSTITUTE(A1, ", ", "|", 5)), len(A1), ""), "", )
- here's a string, here's a very long string over 20 chars, string 3, string 4, another string, string 5, another string 7, number 8
- here's a string, string 3, string 4, another string, string 5
Add Comment
Please, Sign In to add comment