How to Concatenate with a text & number
 

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!!

Try using the text function:

=a1&TEXT(b1,"000")

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
www.ExcelUserConference.com


"|| cypher ||" wrote in message
news:1119656441.59adc4a2a6ee8d9e4d973b9a17d55fe0@t eranews...
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!!