Skip to main content

How to combine cells together

Erin Clazie avatar
Written by Erin Clazie
Updated over 10 months ago

Combining cells together

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

=A1&B1

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:

=A1&" "&B1

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

Did this answer your question?