Forum Discussion
jakeblues1600
Jun 18, 2024Copper Contributor
Find/Replace highlight cells with nothing in them
Hi all Find/Replace highlight cells with nothing in them, and when I delete these cells the new ones are just the same. Any ideas?
JKPieterse
Jun 18, 2024Silver Contributor
What is your intention precisely?
- jakeblues1600Jun 18, 2024Copper ContributorThe spurious data keeps messing with the sort function, it puts gaps in my database
- HansVogelaarJun 18, 2024MVP
Did you try right-clicking the selection, then selecting Delete from the context menu, and selecting Shift cells up in the dialog?