Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import comma delimited text | Excel Discussion (Misc queries) | |||
Formula appears as text | Excel Worksheet Functions | |||
how i use formula when i put the comma myself | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) |