Reformattng EMAIL addresses incolumn

A

Ashish Mathur

Hi,

You can use this formula in an adjacent cell. I have assumed that the
string is in cell B16

=MID(B16,SEARCH("<",B16,1)+1,SEARCH(">",B16,1)-SEARCH("<",B16,1)-1)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook 365 extremely stubborn 0
Where ELSE does outlook store "contacts"? 1
Determine if workbook is open 2
Exporting Outlook 2007 contact list without losing groups 0
Copying email addresses 3
Blocking junk email 0
Outlook 365 Signatures 0
Have 4 email addresses Want to auto forward all in one of them 0

Top