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
mailto:ABC_DEF@123.commailto:ABC.DEF@456.com
There an underscore between the firstname_Lastname in the top example.
Each cell has an 123.com and a @456.com address in it.
Is it possible to use Find and Replace to just remove the 123.com addresses, or is there another way to get these email addresses separated so I can remove the unwanted items?
Thanks in advance!
DD98
1 Reply
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.
