How to create space after comma in Excel

When we copy data and Excel tables from the internet, we often encounter formatting errors, errors in displaying excess spacing in Excel, and missing spaces after the comma, causing the words to stick together and look quite confusing. With a simple table with little data, you can adjust it manually, but in reality this is not feasible because it is quite manual. To create a space after a comma in Excel, you can use a function or immediately use an available tool to do it, with a quick and very simple method. The article below will guide you to add spaces after commas in Excel.

1. Create space after comma using Excel function

To create space after the comma, we will combine the TRIM function with the SUBSTITUTE function. In the first cell, enter the formula =TRIM(SUBSTITUTE(B22,",",", ")) and then press Enter.

How to create space after comma in Excel Picture 1

You will then get the results of characters with extra spaces after the comma. Drag the first cell results down to the remaining cells to complete the table.

How to create space after comma in Excel Picture 2

2. Create space after comma using Find and Replace Excel

In addition to using the Excel function above, we can also immediately use the Find and Replace tool in Excel to change characters in the Excel data table.

First, highlight the data area you want to change and then press Ctrl + H to open the Find and Replace tool.

In the new interface that appears, click on the Replace tab . In the Find what section , enter a comma , and in Replace with , enter a comma and a space . Click Replace All to replace everything.

How to create space after comma in Excel Picture 3

You will now see a notification about the number of positions that need to be replaced, click OK to complete. The resulting data has been separated by commas.

How to create space after comma in Excel Picture 4

Marvin Fry

Update 16 October 2023