Filling down text in increments of three
Do you want the text "2 Steps" to appear in A1 etc?
If so, put the formula =(INT((ROW(B1)-1)/3)+2)&" Steps"
in cell A1 and copy it down.
Sam
"Josh W" wrote:
How can I fill a worksheet all the way down with the following:
A1=2 steps
A2=2 steps
A3=2 steps
A4=3 steps
A5=3 steps
A6=3 steps
A7=4 steps
A8=4 steps
A9=4 steps
And so on, each in increments of three, all the way down the sheet. I asked
the same question yesterday for numbers only without text and got some
excellent formulas for that. Today I specifically need to enter the number
and the text in the same cell - "4 steps". Thanks. Excel 2003
|