Excel formula for this...

[Max Sand]

Ok i want an excel formula to do this hopefully simple task...

Say i have cell A1 with the word "dog" in it and cell B2 with the word "Cat"
in it i want cell H5 to have the data in the previously mentioned cells so
that it reads "dog, Cat"

So in english i guess i want multiple cell values in once cell separated by
a space or a comma or whatever.

Thanks

Max

 

[Rafael Ortiz]

Try:

=A1&", "&B2

MRO

 

[Max Sand]

Awsome, i have no idea why i didnt get that - thanks for that MRO

Max