Auto increment by 1 within text

[hbilalarif]

1.Click

2.Drop

3.Create

4.Save

5.Run

6.Print


How to increment above numbers in excel cell automatically instead of typing number manually.

 

[DaveTurton]

You could use two columns to enter data,


For example column A contains numbers 1 to 100

Column B contains your text preceded by "." (e.g. .Click)

C1 contains the formula

=A1&B1

- drag this formula down

Your list will form in columns C

 

[anand_babu]

Hi,


If your question is regarding increasing the number you can do any of these.


1. Type the formula =row() (if data starts from first row)


2. in cell B1 type formula =A1+1


Thanks