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