Prev: dashed line after print preview
Next: Multiple numbers in a cell separated by a comma, need separate cel
From: rach94 on 4 Mar 2010 20:20
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!
From: Pete_UK on 4 Mar 2010 20:39
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 <rac...(a)discussions.microsoft.com> 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!

From: Dave Peterson on 4 Mar 2010 20:47
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
 | 
Pages: 1
Prev: dashed line after print preview
Next: Multiple numbers in a cell separated by a comma, need separate cel