Hi, i need a formula to remove an email address from a long string of text, i exported my hotmail account contacts on to a spreadsheet but each contact has been put in to 1 cell e.g.




A `
1 Contact 1 contact1@contactemail.co.uk 123 contact street
2 Contact 2 contact2@contactemail.co.uk 1233 contact street

etc
etc.