I have email addresses within long text strings in cells which I need to extract - the email address can be anywhere in the string but can be identified by the @ then a space before the start and a space after eg: from the below example:
asdfh ald lksdfh aldjk sue@fred.co.uk aksdfh alkjdh need sue@fred.co.uk
akdflajds hflakjhdflkahsdkh sue@george.co.uk asdkfh aksdh faldj need sue@george.co.uk
asdkhf alksdjh fa tom@white.co.uk ksdhf askdjh faldj need tom@while.co.uk
Can anyone kindly point me in the direction to extract the email addresses on its own into a new cell?
Bookmarks