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.

 
N

netman

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

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel Linking Multiple cells to One cell for Results 0
Copying of non-consecutive, columnar data into consecutive-columnarcells 3
Reading the part [[email protected]] of a "John Smith [[email protected]] " 1
Access Access 2007 Delete Part of Text 0
Excel And Notepad 3
Excel Removing the last 7 characters of cell in excel 0
Microsoft Excel – How to copy cells to a different worksheet on every nth row. 0

Top