Excel formula for this...

  • Thread starter Thread starter Max Sand
  • Start date Start date
M

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
 
Max Sand said:
Awsome, i have no idea why i didnt get that - thanks for that MRO

Max


cells
Click to expand...
After you do this, you may then want to COPY the new column of data (dog,
cat) then Paste Special... Values into another column... then you can delete
the original columns "dog" "cat" and "dog, cat"... otherwise you will need
to hide the individual columns (but if you delete the data then your
concatenated column will fail).

Good luck.
 
Back
Top