Solved How do I extract just the email address from a excel cell?

December 1, 2016 at 07:33:34
Specs: Macintosh
I have an excel file and the data in each cell is listed as:

[info@email.co.uk](mailto:info@email.co.uk)

How do I create a formula to extract just the email address and put it into a new cell?


See More: How do I extract just the email address from a excel cell?

Report •

#1
December 1, 2016 at 07:47:36
✔ Best Answer
If your data is always in the exact same format of:

[info@email.co.uk](mailto:info@email.co.uk)

Then this formula will extract the first email address
(between the square brackets):

=MID(A1,2,FIND("]",A1)-2)

See how that works for you.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question