I have the following format in Excel and I am trying to extract the data between the characters:
First Last <email@example.com>
I need to extract the email address between < and > into its own cell
This question came from our site for professional and enthusiast programmers.
use the following formula, assuming your data is in cell A2
To avoid error message if your data is not conforming, you can use the following in excel 2007 and up:
For maybe a simpler approach, or maybe just a different approach without formulas.
You can do a
Done (unless some of your data doesn't conform!!!)