Hi Experts,

I'm wondering if it is possible in Excel to do something like this:

Some_33_Item_01
Some_33_Item_01
<blank
Some_33_Item_02
Some_33_Item_02
<blank
Some_33_Item_03
Some_33_Item_03

using fill series or mouse (drag/drop) operation?
I have thousands of rows to do, and don't want to do it on by one.

kind regards,

Maybe...

Put this in A1:
="Some_33_Item_"&TEXT(INT(ROW()/3)+1,"00")

And copy it to A2.

Then select A1:A3 (3 cells) and drag down as far as you want.

But if you have thousands of rows to do, you may want to change the final
numeric characters to have more than 2 digits.

And if the Some_33_Item_ varies, you'll want to post those details, too.

Ollie_new_Excel_user wrote:

Hi Experts,

I'm wondering if it is possible in Excel to do something like this:

Some_33_Item_01
Some_33_Item_01
<blank
Some_33_Item_02
Some_33_Item_02
<blank
Some_33_Item_03
Some_33_Item_03

using fill series or mouse (drag/drop) operation?
I have thousands of rows to do, and don't want to do it on by one.

kind regards,

--

Dave Peterson

Hi Dave it works!!

My mistake was that for column A2, instead of copying the formula,
I only copied the value, I think that is why...

Again, thanks,

Ollie


"Dave Peterson" wrote:

Maybe...

Put this in A1:
="Some_33_Item_"&TEXT(INT(ROW()/3)+1,"00")

And copy it to A2.

Then select A1:A3 (3 cells) and drag down as far as you want.

But if you have thousands of rows to do, you may want to change the final
numeric characters to have more than 2 digits.

And if the Some_33_Item_ varies, you'll want to post those details, too.

Ollie_new_Excel_user wrote:

Hi Experts,

I'm wondering if it is possible in Excel to do something like this:

Some_33_Item_01
Some_33_Item_01
<blank
Some_33_Item_02
Some_33_Item_02
<blank
Some_33_Item_03
Some_33_Item_03

using fill series or mouse (drag/drop) operation?
I have thousands of rows to do, and don't want to do it on by one.

kind regards,

--

Dave Peterson