Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Double Quotes | New Users to Excel | |||
Double Quotes | Excel Discussion (Misc queries) | |||
Save As CSV, double quotes | Excel Discussion (Misc queries) | |||
Double Quotes | Excel Programming | |||
Double Quotes | Excel Programming |