Concatenate multiple columns

[nando88]

I need a function or any other method to concatenate multiple function, add "|", and replace " " with "%20", without having to do this 1 by 1.
If someone could show me how to do this, I would be really grateful.
Thanks.

 

[63falcondude]

To concatenate A1, B1, and C1 with "|" as a separator:

=A1&"|"&B1&"|"&C1

To replace all spaces in the concatenated formula with "%20":

=SUBSTITUTE(A1&"|"&B1&"|"&C1," ","%20")