Forum Discussion
Using wildcards in Find and Replace to modify an Excel SS
I have a spreadsheet that contains a column of email addresses - almost 8000 of them. They are in the following formats in the same cells all in one huge column: mailto:ABC_DEF@123.com mail...
If the column doesn't contain a header in its top cell, insert one (e.g. Email).
Select the column.
On the Home tab, click Sort & Filter > Filter.
Click the filter drop-down arrow in the header cell.
Select Text Filter > Ends with...
Enter 123.com in the box, then click OK.
Either select all visible cells, then delete them (choosing Shift cells up), or select all visible rows and delete them.