Deleting spaces in blank cells

[scubadiver]

I have some records which have blank cells that contain spaces. How can I
delete these spaces without deleting spaces in other cells which contain
information.

Does this make sense?

thanks

 

[Pete_UK]

Apply Autofilter to the appropriate columns, and in the filter pull-
down select <Blanks>. Then click on the top-most visible cell and
press the <delete> key to remove any spaces that might be there. Then
copy this cell and paste it onto the other visible cells. Then select
All from the filter pull-down.

Hope this helps.

Pete

 

[Max]

Try using TRIM to remove extraneous spaces
Eg, in B1, copied down: =TRIM(A1)
Then if required, copy col B and overwrite col A with a paste special as
values. Then delete col B