Deleting spaces in blank cells

  • Thread starter Thread starter scubadiver
  • Start date Start date
S

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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting blank spaces in cells 4
Remove blank space in front of text in multiple cells at once 2
Deleting leading spaces in a cell 4
Macro to remove trailing spaces in cells 2
deleting space in cell behind text 1
If blank do nothing 2
How do I remove extra space when text wrapping? 2
How to add a space after each text value in all the cells in a row 4

Back
Top