Deleting spaces in blank cells
 

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

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

Deleting spaces in blank cells
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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