Hello,

I'm wondering what the easiest way would be to Concatenate an unknown amount of textual cells into a single string seperated with a specified character?

For example:
   A1         B1         C1          D1
Hi There   It's Me      Hiya!     It's you!
I want to be able to say, I want to start in A1, the text may not end in D1, but can use in a IV1.end(xltoright) to find it, and have it turn out looking like this:

Hi There,It's Me,Hiya!,It's you!
Thanks!