Tricky question to ask this one!

I have a shhet with data in it, I press CTRL+END and it goes to empty cells
way down the bottom of the sheet (there was text in these cells once but not
any more).

When I press CTRL+END I want it to go to the last cell with text it it and
not further. Is there a way of totally clearing empty cells?

Thanks