Concatenating several cells

[managingcrap]

I want to combine all the words on column B into one cell and separated by " | " found on cell B2. I have 1,000 words to combine and have each word separate by that "|". Sometimes, the words in each shell is more like a phrase. So, some cells have phrases and not just a single word.

I want the result to look like the one on C6.

Is there an easy way to get a formula/function to capture 1,000 or more words?

Thanks,

[jeffreybrown]

The easiest method is to use a UDF which can be found here.

You apply it as: =ConcatAll(A2:A6,B2)

[6StringJazzer]

Here is an alternative that is not as robust but is targeted specifically towards the use described in the OP and so also simpler:

Please Login or Register  to view this content.

Implemented in attached