Excel Question on Excel Cells - removing part of a cell.

M

mmohdi1

Joined
Feb 17, 2009
Messages
1
Reaction score
0
I have a CSV file which is a GAL file from an exchange server. The CSV has 1500 lines. The email field is in the format of :-

smith, John ((e-mail address removed))
I would like to remove the friendly name and the brackets for all 1500 cells so it looks like this:-
(e-mail address removed)

I am sure it is pretty simple and someone can help.

 
You can use find and replace command:
Find *((E-Mail Removed))
Replace (E-Mail Removed)
 
Back
Top