Hi there
I'd like to remove all text from within a cell that isn't part of an email address and copy it to the adjacent cell.
For example, A1 might contain
Please drop me an email at [email protected] and I'll come back to you straight away.
What I'd like is for A1 to just contain
[email protected]
And B1 to contain
Please drop me an email at and I'll come back to you straight away.
Thanks as ever for the help
Steve
Bookmarks