In such cases, you can add space by indenting the data in one of the columns. You can also increase the space between columns in your Excel chart using the Data Series formatting tool.

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

The second Excel drop down list will display the representatives in that region. To the right, you see labels and formats in preparation for creating the Excel drop down list.

How to Convert Trailing Spaces in Excel. In Microsoft Excel, removing spaces from the end of the text in a cell to clean up company data takes one step when you use the TRIM function, which lops ...