View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Robert Kim Robert Kim is offline
external usenet poster
 
Posts: 5
Default 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