how to remove double quotes?
 

Hi, all. I have many cells with names in them. The names are in double
quotes such as "4_cell 5_9-10-04". Is there an easy MS Excel command to
wasily remove all the double quotes in many cells at once so the label is
only like 4_cell 5_9-10-04 without double quotes around it? TIA.

Bob

how to remove double quotes?
 

Highlight the cells containing what you describe;
Goto the Menu and select - Edit, Replace, In the Find What box enter "
In the Replace with box <<leave blank, Click Replace ALL
HTH


"Robert Kim" wrote in message
urdue.edu...
Hi, all. I have many cells with names in them. The names are in double
quotes such as "4_cell 5_9-10-04". Is there an easy MS Excel command to
wasily remove all the double quotes in many cells at once so the label is
only like 4_cell 5_9-10-04 without double quotes around it? TIA.

Bob

how to remove double quotes?
 

Hi Robert,
Just do a find " and leave replace blank, click replace all. They should all
be gone...
DJ

"Robert Kim" wrote:

Hi, all. I have many cells with names in them. The names are in double
quotes such as "4_cell 5_9-10-04". Is there an easy MS Excel command to
wasily remove all the double quotes in many cells at once so the label is
only like 4_cell 5_9-10-04 without double quotes around it? TIA.

Bob

how to remove double quotes?
 

Thank you, Jim! Worked great!

Bob


On Tue, 28 Sep 2004, Jim May wrote:

Highlight the cells containing what you describe;
Goto the Menu and select - Edit, Replace, In the Find What box enter "
In the Replace with box <<leave blank, Click Replace ALL
HTH


"Robert Kim" wrote in message
urdue.edu...
Hi, all. I have many cells with names in them. The names are in double
quotes such as "4_cell 5_9-10-04". Is there an easy MS Excel command to
wasily remove all the double quotes in many cells at once so the label is
only like 4_cell 5_9-10-04 without double quotes around it? TIA.

Bob

how to remove double quotes?
 

Thank you, DJ! Very much appreciated!

Bob


On Tue, 28 Sep 2004, [Utf-8] Duncan_J wrote:
Hi Robert,
Just do a find " and leave replace blank, click replace all. They should all
be gone...
DJ

"Robert Kim" wrote:

Hi, all. I have many cells with names in them. The names are in double
quotes such as "4_cell 5_9-10-04". Is there an easy MS Excel command to
wasily remove all the double quotes in many cells at once so the label is
only like 4_cell 5_9-10-04 without double quotes around it? TIA.

Bob