how to remove double quotes?

R

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
 
J

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
 
D

Duncan_J

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

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
 

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