Custom filling of cells
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! |
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! |
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 |
All times are GMT +1. The time now is 03:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com