Good day everyone,
I'll try to be as clear as possible with this question. I have a column with 500 rows and they contain different data but they all have an email address in them.
i.e.
row A1 : Hello my name is John and my email is john@mail.com thanks
row A2 : Hi, my name is Sam and I have an email sam@sam.com good bye.
row.....etc.

what do I want to do? I want to get all email addresses from all rows, without all the rest of the text. I dont know how to do that, but I imagine it would be some sort of rule that detects the @ symbol, then selects the text before the @ until the first space, and then the text after the @ symbol until the first space, and deletes everything else in the cell.

maybe Im just nuts and this is not possible but I thought I would ask the experts.

thanks all for your help!