Select Data > Text to Columns. ... According to Excel, it’s like CONCATENATE, but better, because it’s shorter, easier to type, and supports range references as opposed to just cell references.

Select all of the data. Click Home > Find & Select > Go To Special , select “Blanks,” and click “OK.” Right-click on a selected cell and select “Delete” from the dropdown menu.

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.

Excel’s Go To feature lets you quickly select all the blank rows in the selection. Now, you’re ready to delete those rows. Don’t do anything to deselect the selection.

Matching One Column Data with Another in Excel. If you don't have a keen eye and a perfect memory, ... Click the "Home" tab followed by "Find & Select" to open a drop-down menu.