delete blank cells and shift data left

**rhudgins** · 07-30-2010, 03:53 PM

How can I remove the spaces in the data in row 4 to look like the data in row 6?

**martindwilson** · 07-30-2010, 04:03 PM

As long as they are blank (in your sample they are not)
select range
edit goto special blanks/ right click/ delete/ shift cells left

**rhudgins** · 07-30-2010, 04:05 PM

I have tried this. The cells in my range will not be blank..

**martindwilson** · 07-30-2010, 04:10 PM

why are they not blank?

**rhudgins** · 07-30-2010, 04:10 PM

because they are copied as values from a formula. Is there a way to make them blank after they have been copied from the formula?

**martindwilson** · 07-30-2010, 07:30 PM

good point, i never noticed that. hmm and short of selecting deselecting cell isblank returns false hmmmmmmm

**shg** · 07-30-2010, 08:11 PM

You can select the values, and in the VBE Immediate window, enter

Selection.Value = Selection.Value

Then proceed as Martin described.

**rhudgins** · 07-30-2010, 11:16 PM

thanks i figured it out

Re: delete blank cells and shift data left