Spreadsheet Tips

How to Join Cells With a Space Between them in Excel

April 05, 2018
How to Join Cells With a Space Between them in Excel

It's easy enough to join up cells in Excel. You can use the & symbol to join cells. But, how can you join cells and add a space between them so that your data stays reasonable?

In this case, just use the pattern &" "& between two strings of data. This single space in quotation marks is going to add a space while you're joining those cells up.