Using CONCATENATE and need to increase last digit by 1

Good Afternoon!

I've received a lot of great help from this forum before and i'm hoping someone has a solution

I'm creating a template that will automatically generate the names of computers on a network

I have 2 named cells - HOST_PREFIX and HOST_SUFFIX - this is where you enter the names of the computers.

here's my concatenate formula

=CONCATENATE(HOST_PREFIX,HOST_SUFFIX,01)

If i enter CORP in the Host Prefix and then PC in the host suffix it will return the result
CORPPC1

I'd like to have it return:
CORPPC01
But i've had no luck with that.

What i REALLY need is the ability to copy/paste or CTRL+DRAG and have it count up, resulting in
CORPPC01
CORPPC02
CORPPC03, etc.

Attached is my sample spreadsheet.

any help would be greatly appreciated!

Thanks!

EXACTLY what i needed!

Thanks a lot!

Chris

OK, I'm really exposing my Newbie status here...

I need to be able to move these cells up and down in the sheet, and it seems as though it is dependant on how many cells away the reference cell is.

What i need is an ABSOLUTE starting point and have the results generated relative to that.

SO if i put my reference cell in B9 and call it HOST_NAME, i've started it out as count 00.
CORPPC00

If i put the following formula in B10 it returns the result CORPPC01 as i hope.

but if i insert a few blank spaces, B13 reports CORPPC05 where i had hoped it would report CORPPC01 so that it would re-start the numbering.

another desired feature is to have them count up by 2 so that i may arrange them in different columns by evens and odds.

Thanks again!

Chris