Deleting spaces in blank cells
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
On Feb 21, 11:30*am, scubadiver
wrote:
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
|