Any Command to remove spaces

  • Thread starter Thread starter SD
  • Start date Start date
S

SD

Hello All,

Is there a command to remove all the spaces in the cell ( prefix,
suffix and in between ) basically all spaces in the cell .

Thanks in advance.
SD
 
Select the range (at least two cells)
and
Edit|replace
what: (space character)
with: (leave blank)
replace all
 
You can use Find & Replace (CTRL-H). Highlight the cells, CTRL-H,
then:

Find what: type a single space
Replace with: leave blank
Click Replace All

Hope this helps.

Pete
 
Hi,

If you only want to remove extra spaces between word, but leave 1 then
consider the =TRIM(A1) function.
 
Back
Top