How to edit data according to a specific template?

Question

excel

There is a huge spreadsheet in excel. The data in the column is stored in several options:
801592 47190 8029 8868254;[email protected];
8029 144 96 74;394 14 06; [email protected];
[email protected];
That is, either a number / several + email, or just email. always separated by a semicolon. Is it possible to remove all numbers from the table, leaving only email? well, at the same time remove the semicolon after the email.

Answer 1

Try so:
Select a column with the data.
Click "Data" -> "Text by Columns".
With separators - "semicolon" separator...