How to merge two cells, add a space and a comma

Question

I have two cells:

Cell 1 - Toronto
Cell 2 - ON

I want to merge into one cell and have it say Toronto, ON (adding a , and space after Toronto).

Answer 1

Assuming Cell 1 is A1 and Cell 2 is B1, please try:

 =A1&", "&B1  

I think you want to CONCATENATE rather than merge (which is best avoided at all costs).

An alternative version is:

=CONCATENATE(A1,", ",B1)