How to Concatenate with a text & number

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 ||" <[email protected]> wrote in message
news:1119656441.59adc4a2a6ee8d9e4d973b9a17d55fe0@teranews...
> 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 ||" <[email protected]> wrote in message
news:1119656441.59adc4a2a6ee8d9e4d973b9a17d55fe0@teranews...
> 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!!
>
>

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 ||" <[email protected]> wrote in message
news:1119656441.59adc4a2a6ee8d9e4d973b9a17d55fe0@teranews...
> 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!!
>
>