remove spacing

[Guest]

Hi,

i hv a column that contains all the model name. I want to remove the spacing
in the model name. e.g. from abc 123 to abc123. May i know how to do it.

Thank you

 

[Guest]

Select the col range
Click Edit>Replace
Type a space in the "Find what:" box
Leave "Replace with:" empty
Click Replace All

 

[Dave Peterson]

Select the range to fix
Edit|Replace
what: (spacebar)
with: (leave empty)
replace all