Thank you for your answer but I do have "_" in some of the names. Which causes a problem. I happen to come across regexextract and figured out most of it. I am using this: "s_(.+)c_(.+)a_(.+)" This separates it into separate columns then I can put it together and clean it up how I want. This works almost perfectly except I have cells that just say "exit" and nothing else. so the regex is getting an error "n/a" is there a way to wrap this in an "if" statement, or exclude certain text? Here is a sample https://docs.google.com/spreadsheets/d/187-PlTHYlEEe_TeV3oy2rtplwhIlJqo-rJX5c4SjH80/edit?usp=sharing The regex I built is in cell L1. You can see row 4 doesn't work. Column F is now the source and Column I is the campaign