Forum Discussion
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...) !
5 Replies
- 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)" ... :)
Another option:
=TEXT(ROW(),"(#)")
Exactly, thank you. More close to required string
=TEXT(ROW(),"1 (#)")
just cosmetic
Hi Nils,
You may build this index (1,2,3,...) in one column, in next one enter in firs 3-4 cells your sequence and Flash Fill the rest. If Flash Fill starts automatically substitute wrong sequence (e.g. increase first symbol which shall be 1) continue with typing few more cells in second column - Flash Fill shall finally recognize correct sequence.
If use formulas easier something like
= "1 (" & ROW() & ")"fill, copy and after that paste as values
got it
1 (
1
)
then =CONCATENATE(A1, A2, A3)
and drag with mouse! (someone else taught me...) !
