How to Concatenate with a text & number

[|| cypher ||]

A1 will have a 4 digit number and letter (ex: 1332s)
B1 will have a number between 1 & 999

I am trying to get C1 to concatenate the two, taking the B1 value and
forcing it to take up 3 spaces
EXAMPLE: 1322s002 or 1322s097 or 1322s433

So basically I need to get the number portion from B1 to have 3 place
holders

currently if B1 is less than 100, ie 99 or 72 or 3 or something, C1 shows up
as:
1322s99, or 1322s72, or 1322s3 instead of:
1322s099, 1322s072, and 1322s003

Any ideas out there?

Thanks!!

 

[Damon Longworth]

Try using the text function:

=a1&TEXT(b1,"000")