Using CONCATENATE and need to increase last digit by 1

[FunkyDragon]

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!