Updating Text Values

[mbaumhofer]

I am creating a single line spreadsheet, increasing the value of the box by 1 each time.

A1=NCP001

Since this is a text box, how do I increase the value in that box by 1 to make A2 NCP002, A3 NCP003, etc etc.

Thanks for the help.

 

[mikerickson]

Put ="NCP"&TEXT(ROW(A1),"000") in A1 and drag down.

 

[taurean]

By textbox if you mean formatted as "text" and it is in cell A1 then: simply use Autofill option (dragging down). Excel will automatically update the numeric part!

 

[mbaumhofer]

It has been so long since I used Excel in this fashion.

I thank you sir, you just saved me alot of typing.

Thanks Again

 

[wigi]

Even without a formula, it will work. Type in A1:

NCP001

grab the fill handle (lower right corner of the selected cell A1), and drag down.