Where the contents of A1 and B1 are the cells you want to combine.

If you need a space between the values (for example if you are combining first and last names), be sure to add a space in quotations, like so:

This way a name will read as 'John Smith', rather than 'JohnSmith'