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:
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:A1 B1 C1 D1 Hi There It's Me Hiya! It's you!
Thanks!Hi There,It's Me,Hiya!,It's you!