how to remove double quotes?

[Robert Kim]

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

 

[Jim May]

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

 

[Duncan_J]

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

 

[Robert Kim]

Thank you, Jim! Worked great!

Bob

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]

Thank you, DJ! Very much appreciated!

Bob

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