How can i delete an empty cell while looping in excel?

[Prateek_Valvi]

If i run a loop in excel and find a cell empty or null how can i delete it and move the remaining cells up, Delete Range isnt working here as the cell position is dynamic depending on the loop where it can occur!

[NIVED_NAMBIAR (NIVED N)]

Hi @Prateek_Valvi

Did u mean to delete the rows whose any of cells is empty?

[Prateek_Valvi]

No Just the Cell

[NIVED_NAMBIAR (NIVED N)]

Can u share the sample excel file please ? @Prateek_Valvi

[Prateek_Valvi]

Text.xlsx (8.7 KB)
@NIVED_NAMBIAR Here it is

[WhenCutEsh (Venkatesh Nallana)]

in your example read second column remove empty cells and re-write the column to excel, if you have more columns than one then iterate over columns. once you format it you can use as required.

[Prateek_Valvi]

Can u please elaborate?