Forum Discussion
Solved
rows of increasing value?
Hello, I have a cell into which I type "1 (1)" one row down I type in "1 (2)" how do I get excel to automatically continue these rows (i.e. "1 (3)", 1 (4"), "1 (5)",... "1 (999)")? thanks ...
got it
1 (
1
)
then =CONCATENATE(A1, A2, A3)
and drag with mouse! (someone else taught me...) !
For example, I know Excel has a basic ability where you can insert 1, 2, 3 on separate rows and then the mouse to drag down, extending the numbers. Sadly this doesn't seem to work when you foolishly start with "1 (1)" ... :)
got it
1 (
1
)
then =CONCATENATE(A1, A2, A3)
and drag with mouse! (someone else taught me...) !