Need help with formulas

[JMS786]

I need to create a formula for end use as labels. The info in the first cell
is ABC1107J100 and then I need it to increase by one in each cell after A1,
i.e. 100, 101, 102, 103, etc. I then need to print these in Word label
format. Please help!!!!!!!

Thanks,
JMS786

 

[Mike H]

Simply drag it down

Mike

 

[Jacob Skaria]

Enter the first text in a cell and dra/copy down as required.

ABC1107J100

If this post helps click Yes

 

[abe1952]

This is a brilliant answer, Mike.

Simply drag it down

Mike