Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
inserting quotation marks
I want to insert quotes in front of text in 1280 cells that already have
values in them. Is there an easy way to do this with a macro. |
#2
|
|||
|
|||
Select those cells
Dim cell For Each cell In Selection cell.Value = """" & cell.Value Next cell -- HTH RP (remove nothere from the email address if mailing direct) "dave glynn" wrote in message ... I want to insert quotes in front of text in 1280 cells that already have values in them. Is there an easy way to do this with a macro. |
#3
|
|||
|
|||
Thanks Bob
Kind regards Dave "Bob Phillips" wrote: Select those cells Dim cell For Each cell In Selection cell.Value = """" & cell.Value Next cell -- HTH RP (remove nothere from the email address if mailing direct) "dave glynn" wrote in message ... I want to insert quotes in front of text in 1280 cells that already have values in them. Is there an easy way to do this with a macro. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Y-axis tick marks in middle of chart? | Charts and Charting in Excel | |||
Use quotation marks in a formula to display a qty in feet and inc. | Excel Worksheet Functions | |||
How do I concatenate text that actually contains quotation marks? | Excel Worksheet Functions | |||
Excel Quotation Marks! | Excel Discussion (Misc queries) | |||
Inserting Footer - Ajit | Excel Discussion (Misc queries) |