Adding space between Excel columns is usually a simple matter of increasing your column widths. But when the columns contain different types of data, such as numbers and text, increasing the width ...

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