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