Formula for adding a comma in front of text in a cell
 

I need to add a comma in front of the text in a cell and copy the same for
4000 rows. Can you help me with a fromula or a macro. Thanks and regards

Hi Shelley

="," & A1

where your text is in cell A1, this can then be filled down the 4000 rows
using the autofill handle (move your cursor over the bottom right hand
corner of the cell and when you see the + double click)


--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Shelley" wrote in message
...
I need to add a comma in front of the text in a cell and copy the same for
4000 rows. Can you help me with a fromula or a macro. Thanks and regards

Try this macro

Sub add_comma()
For myrow = 1 To 10
Cells(myrow, 1).Value = "," & Cells(myrow, 1).Value
Next myrow
End Sub

Ian

"Shelley" wrote in message
...
I need to add a comma in front of the text in a cell and copy the same for
4000 rows. Can you help me with a fromula or a macro. Thanks and regards

Thanks Julie. It was great

"JulieD" wrote:

Hi Shelley

="," & A1

where your text is in cell A1, this can then be filled down the 4000 rows
using the autofill handle (move your cursor over the bottom right hand
corner of the cell and when you see the + double click)


--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Shelley" wrote in message
...
I need to add a comma in front of the text in a cell and copy the same for
4000 rows. Can you help me with a fromula or a macro. Thanks and regards

you're welcome and thanks for the feedback


"Shelley" wrote in message
...
Thanks Julie. It was great

"JulieD" wrote:

Hi Shelley

="," & A1

where your text is in cell A1, this can then be filled down the 4000 rows
using the autofill handle (move your cursor over the bottom right hand
corner of the cell and when you see the + double click)


--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Shelley" wrote in message
...
I need to add a comma in front of the text in a cell and copy the same
for
4000 rows. Can you help me with a fromula or a macro. Thanks and
regards