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 ...

If you want to add space between names, separate the inverted commas in the formula with space. Now, apply the same formula to all the remaining cells by using the Fill Handle.

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: ...

You can remove leading, trailing, and extra spaces between characters and numbers in Excel using TRIM(), SUBSTITUTE() or Find and Replace.