S sdm1059 Mar 10, 2009 #1 How do I reformat email addresses in entire column from Joe Smith<[email protected]> to (e-mail address removed)
How do I reformat email addresses in entire column from Joe Smith<[email protected]> to (e-mail address removed)
A Ashish Mathur Mar 10, 2009 #2 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
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
