How to quickly add comma between words in Excel?
Supposing there are some words which are separated by space in a cell, now you want to add comma between these words as below screenshot shown, how can you quickly handle it without adding one by one in Excel? I have two methods that can handle it.
add same text to a specific location of each cell in Excel
|How could you add text or characters to the beginning of multiple cells, or add text or characters to the end of cells or insert text or characters between existing text? With Add Text utility of Kutools for Excel, you can quickly apply the following operations: . Click for 60 days free trial!|
|Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days.|
With Find and Replace function can quickly find the spaces which between words and replace with space following commas.
1. Select the cells you want to add comma between words, press Ctrl + H to enable Find and Replace function.
2. Then in the Find what textbox, type spacebar to enter a space into it, go to the Replace with textbox, type spacebar once time and press , into it.
3. Click Replace All, all spaces have been replaced with space + comma.
4. Click OK > Close to exit the Find and Replace function.
If you do not want to change the original data, maybe you can try SUBSTITUTE function.
Select a cell which you will place result in, type this =SUBSTITUTE(TRIM(A1)," ",", ") into it, press Enter key, and drag fill handle down to apply the formula to cells you need.