i am looking for a macro to start on columns c2, d2, e2, f2, g2 and merge those together with a separator of |, and put the results on b2

I know you can do it with =c2&e2 but i have 20,000 products i have to do this to and copy and paste is to much time, and i would like to create a shortcut to start it.

example:


Component Monitor LCD Monitor 20"/20.1" LCD Monitor

Needs to be this.

Component|Monitor|LCD Monitor|20"/20.1" LCD Monitor

thanks