I'm trying to figure out how to do the following:
Given: "123 W. Main Street"
Split: by " "
Substitute: Each " " for "+"
I thought using a combination of Concatenate(Substitute(Split())) would be the answer, but I can't seem to find the right combination.
Solved! Go to Solution.