To remove spaces between characters and numbers in the above example, we may use the Find and Replace feature in Excel as follows: Select the data range. Click on the Find & Select dropdown in the ...

For example, if cell A1 contains extra spaces between words, then use the =TRIM(A1) function in some other cell and it will remove the extra spaces. After that, you can copy the output in cell A1.