Sorting a column that has blank rows

[SriramDorai]

Hello,

i am working on a project that needs me to sort a column in ascending order.

Since the column has lots of blank rows, i could not sort them ideally. I want my sort to happen in such a way that it should start with blank cells and end up with cells having data(ascending)

[Chrismdlz]

Hi,
Could you filter on the blank cells and highlight the cells in a different colour? Then you could firstly sort ascending, then sort by cell colour, selecting the blank cell colour at the top. This would bring the blanks to the top but keep the others in ascending order. Bit of a faff but I can't think of another way at the moment

[MickG]

Use "Find & Select " to change blank cells to "0" then "sort" then Use "Find & Select" to change "0" to Blank cells