Merge the content of 2 cells into 1 (with a comma separating the content)

Hi there,
I would like to know how to combine the content of 2 cells into one cell and have the information separated by a comma.

For example:

CELL 1:
Software 1

CELL 2:
Spreadsheet Software

The desired results is:

CELL 3:
Software 1, Spreadsheet Software


If you can help it would be great  Thanx. Vincent

Hi

=a1&", "&b1

or

=concatenate(a1,", ",b1)

where a1 and b1 contain the strings.


rylo

In a 3rd column use this formula - change column & row numbers as required.


=a1&", "&b1 - this has a space after the commar

Copy formula down the colum

To remove formula & leave values
copy column
Paste column back into same column using PasteSpecial > Values