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

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

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

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