excell

D

dam

need help incrementing a row of inventory numbers (that are preceded by a
letter)
formula to increment U0750 to U0751..to U0850.
also another column of alias for same unit AWWU U0750 to AWWU U0751..to
AWWU U0850.
seems like I did this once in past but have slept since then, thanks for any
help provided
 
O

Otto Moehrbach

Simply enter , say, U0750, into a cell. Then grab the fill handle (the
little square dot at the bottom right corner of the cell) and drag it as far
as you want. The number part will increment. HTH Otto
 
G

Gord Dibben

Enter U0750 in a cell.

Right-click and drag down......release button and select "Fill Series"

Same for AWWU U0750


Gord Dibben MS Excel MVP
 
D

dam

wow..now i really feel like a big dummy. I have spent a bit of time trying
to solve this. thanks for the help.
dam
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Vlookup with an Arrayformula.... HELP! 0
Automatically Incrementing Row in Formula Copied Horizontally AcrossColumns 1
Repeating formulas.... 2
New computer, how do i move outlook 365 ENTIRELY? 0
Help creating a formula that repeats text & increments an integer 3
EXCEL time match 3
Adding a big matrix in Word 2013 5

Top