| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding a single quote and comma to every cell in Excel
I need to make a script where I can add a single quote to the number in each
cell in Excel and after the second quote a comma. Hence the cell would start like 08558952 and afterwards would look like, '08558952', I can't quite seem to get it done, any ideas? TIA, Rod |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding a single quote and comma to every cell in Excel
you don't mention whether you have the loop or not, but this formula will
work, just loop through the cells ActiveCell.Value = "'" & ActiveCell.Value & "'," -- Gary "rodsheffield" wrote in message ... I need to make a script where I can add a single quote to the number in each cell in Excel and after the second quote a comma. Hence the cell would start like 08558952 and afterwards would look like, '08558952', I can't quite seem to get it done, any ideas? TIA, Rod |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding a single quote and comma to every cell in Excel
Gary,
Actually no I don't have a loop in place. What are you suggesting code wise? Thanks again for your help. "Gary Keramidas" wrote: you don't mention whether you have the loop or not, but this formula will work, just loop through the cells ActiveCell.Value = "'" & ActiveCell.Value & "'," -- Gary "rodsheffield" wrote in message ... I need to make a script where I can add a single quote to the number in each cell in Excel and after the second quote a comma. Hence the cell would start like 08558952 and afterwards would look like, '08558952', I can't quite seem to get it done, any ideas? TIA, Rod |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding a single quote and comma to every cell in Excel
why don't you email me what you have
-- Gary "rodsheffield" wrote in message ... Gary, Actually no I don't have a loop in place. What are you suggesting code wise? Thanks again for your help. "Gary Keramidas" wrote: you don't mention whether you have the loop or not, but this formula will work, just loop through the cells ActiveCell.Value = "'" & ActiveCell.Value & "'," -- Gary "rodsheffield" wrote in message ... I need to make a script where I can add a single quote to the number in each cell in Excel and after the second quote a comma. Hence the cell would start like 08558952 and afterwards would look like, '08558952', I can't quite seem to get it done, any ideas? TIA, Rod |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show apostrophe / single quote in cell | Excel Discussion (Misc queries) | |||
| CANNOT Import comma delimted, quote qualifed text file into Excel. | Excel Discussion (Misc queries) | |||
| Single Quote use in cell reference | Excel Worksheet Functions | |||
| How do I display a single quote in a cell? | Excel Discussion (Misc queries) | |||
| Single quote in a textbox disappear when put in cell? | Excel Programming | |||
Hybrid Mode
