How to remove spaces between words in Google Sheets

How to remove spaces between words in google sheets

Step by Step Guide to remove spaces between words in Google Sheets

1. Select all the cells that your want to remove spaces

2. Press ‘Ctrl +H’. On the Find and replace popup box, enter a space in the Find field, and do not enter any characters on the Replace with field.

3. Press Replace all, and it will remove all the spaces between the words in the selected cells.