How to Add Space Between Columns in Excel. Adding space between Excel columns is usually a simple matter of increasing your column widths. But when the columns contain different types of data ...

The above formula combines the names without space in between them. If you want a space between the combined names, you have to add space between the quotation marks or inverted commas in the formula.

To add spaces between concatenated strings you must insert a blank space that is enclosed between a pair of double quote marks: (“ “). Thus the Dr. Jones example’s syntax would be: ...