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

[Guest]

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

 

[JulieD]

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)

 

[IC]

Try this macro

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

Ian

 

[Guest]

Thanks Julie. It was great

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

 

[JulieD]

you're welcome and thanks for the feedback

Thanks Julie. It was great