Custom filling of cells
Assuming you have HBL0052-77 in A1, put this formula in A2:
=LEFT(A1,3)&TEXT(MID(A1,4,4)+1,"0000")&RIGHT(A1,3)
then copy down as required.
Hope this helps.
Pete
On Mar 5, 1:20*am, rach94 wrote:
Hi,
I am filling cells with the formula HBL0052-77 and am wanting to fill the
series down, but only change the number immediately after HBL, not the last
number ie/ so the next numbers in the series would be HBL0053-77, HBL0054-77.
Is there a way to do this?
Thanks for your help!
|