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

You can use the Excel Concatenate function to create a sentence, join and add space between words, comma between words, space between words, etc.

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