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


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.

 
Ad

Advertisements

Joined
Dec 8, 2012
Messages
1
Reaction score
0
You can use find and replace command:
Find *((E-Mail Removed))
Replace (E-Mail Removed)
 

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

Top