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