ExcelBanter - Reformattng EMAIL addresses incolumn

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Reformattng EMAIL addresses incolumn (https://www.excelbanter.com/excel-worksheet-functions/223729-reformattng-email-addresses-incolumn.html)

sdm1059

Reformattng EMAIL addresses incolumn

How do I reformat email addresses in entire column from
Joe to

Ashish Mathur[_2_]

Reformattng EMAIL addresses incolumn

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

"sdm1059" wrote in message
...
How do I reformat email addresses in entire column from
Joe to

All times are GMT +1. The time now is 07:34 AM.