Deleting Blank Cells Wholesale?

Hi --

I have a large excel spreadsheet with over 1,000 rows of data with blank
cells scattered in all different columns. I need a way to bring all data over
to the left and stack up from left to right within eachrow. In other words, I
need an easy, efficient way to delete all of the blank cells in the range so
that all remaining populated cells will shift to the left. Any advice?

Thanks in advance!!

Select whole area, do Edit / Go to / Special / Blanks, then hit Edit /
Delete / Shift cells left.

Regards
Ken..............

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------

"Trey" <[email protected]> wrote in message
news:[email protected]...
> Hi --
>
> I have a large excel spreadsheet with over 1,000 rows of data with blank
> cells scattered in all different columns. I need a way to bring all data
> over
> to the left and stack up from left to right within eachrow. In other
> words, I
> need an easy, efficient way to delete all of the blank cells in the range
> so
> that all remaining populated cells will shift to the left. Any advice?
>
> Thanks in advance!!