Erasing Blank Cell horizontally.

[James8309]

Hello,

I've been trying to figure out this problem all night and I just can't
find the answer T.T

Basically,

I have like 3000 rows and 366 columns of data containing only numbers.
I have one column A filled from A1 till A3000, However columns are not
fully filled horizontally.

for an example, Row 1 will have number at colum A, D, and AA.
Row 2 might have number at colum E, F, Z, AB and AC



i.e.
A B C D E F G H I J K ...
1 2 3 1 0 2
2 2 3 4 2
3 1 8
9 ..
4 1
5 2 4 5
6 2 6 8
7 1
0 8
..
..
..
How do I automatically delete empty cells horizontally so it looks
just like this below?

1 2 3 1 0 2
2 2 3 4 2
3 1 8 9
4 1
5 2 4 5
6 2 6 8
7 1 0 8


Pleae Please HELP

thank you so much!

 

[Lori]

Select blanks by pressing F5 > Special... then Edit > Delete > Shift Left

 

[James8309]

Select blanks by pressing F5 > Special... then Edit > Delete > Shift Left

Thanks for your help but it says "No cells were found" even though
cell contains no formulae or value.

What did I do wrong? T.T

 

[Lori]

Are you sure you selected "blanks" from the Goto Special dialog?

 

[Dave Peterson]

Did those "empty" cells used to contain formulas that evaluated to =""?

And then did you convert those formulas to values?

If yes, then try this first...

Saved from a previous post:

If you want to see what's left in that cell after you convert ="" to values,
try:
Tools|Options|Transition Tab|Toggle Transition Navigation keys on.

Then select one of those cells and look at the formula bar. You'll see an
apostrophe. (Don't forget to toggle the setting to off.)

When I want to clean up this detritus, I do this:

Select the range (ctrl-a a few times to select all the cells)
Edit|Replace
what: (leave blank)
with: $$$$$
replace all

Immediately followed by:
Edit|Replace
what: $$$$$
with: (leave blank)
replace all

 

[Lori]

Another option... Ctrl+F > Find All > Ctrl+A.
Leaving the find box blank will select cells containing "".
Select these cells and then Edit > Delete.