Excel question - cut text from a cell

[UKMuFFiN]

Im trying to make a macro that will grab an email address from a cell and put it into anothercell, the cell containing the email address has other junk in it too which i dont really need at the moment.


I made a macro a few weeks back in Word that found email address and put them all into a new document and so im trying to work from that but i cant seem to find how you select certain text within a cell. I've managed to get a loop finding "@" for the whole column. Any ideas? Kind of urgentish.

Cheers

[luap.h]

Would the Data Menu->Text to Columns help at all? That could split the cell into email and junk

If you give an example of the cell you're trying to parse it would be easier to say

[UKMuFFiN]

That sort of helped cheers, but it still didnt quite sort it because some cells had the email address in a different place in the cell. I'm now pasting the whole column into word and will make a macro there to sort it how i want, don't know why i didnt think of that (my boss told me)

Cheers for you prompt reply though!

Out.