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

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

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