Here is a way to remove blank cells from an array First table has a set of data interspersed with blank cells. Blank cells have been removed from table 2. The steps to be followed are: Select A1:B9 Edit: Go To…: Special: Blanks Edit: Delete Shift cells up ’tis done!
Posts Tagged ‘Go To…’
Remove blank cells
Posted in Uncategorized, tagged Go To... on July 24, 2008 | Leave a Comment »
Author
Search blog
-
Recent posts
-
Blog Stats
- 15,059 hits
Share with others!
What have I used most
Get down to work!
May 2012 M T W T F S S « Jul 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
