I have a column with thousands of rows of data with several blank cells. I only want the data with the values and remove the blank cells. I tried using the Find & Select feature but it did not highlight the blank cells. My guess as to this is that these blank cells were copied from a column full of formulas. I also noticed that the Find & Select feature only works when using the delete button to "delete" each blank cell but given the thousands of data, it won't be a quick task. I have attached an image to help with the visuals. Screenshot 2023-09-14 170619.png