Remove Blank Cells in Excel | Excel Problem Solution

[pixel01]

Hi all,

I have this excel problem: In a column, there are entries (can be characters or number), but there are also some blank cells. How could I remove all the blank cells so that the column is shorter.
Here I attached an illustration

Thanks for any comments

 

[Andre]

Simple, select the cells to be removed. Use shift or control for multiple selections; go drop menu point "edit" and find function "delete". You will be prompted what to do with the remaining cells, to move up or left, etc.

Success

 

[pixel01]

Simple, select the cells to be removed. Use shift or control for multiple selections; go drop menu point "edit" and find function "delete". You will be prompted what to do with the remaining cells, to move up or left, etc.

Success

Thanks Andre.
The thing is that in case there are hundreds of cells, to select blank cells is not simple.
Blank cells appear randomly.

 

[acvwJosh]

To select just the blank cells, you can go to 'Edit', then 'Go To', click 'Special', and then select 'Blank Cells'. After that, delete them just like Andre said. You'll want to shift the remaining cells up, since you're removing blank cells in columns. Hope that helps.

Josh

 

[pixel01]

Thank you Josh, it seems I have solved the problem.
Once again thanks Andre and Happy New Year to all of you