Custom filling of cells
I would use a formula.
If the data starts in Row 1, then this formula would work ok:
="HBL"&text(row()+51,"0000")&"-77"
And drag down.
And then copy|paste special values when you're done.
Adjust that 51 to what you need to get to 52 if you don't start in row 1.
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!
--
Dave Peterson
|