combine text and number with preceeding zeroes
 

Mac, here is one way
=A1&" 000"&B1&"; "&C1
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

"mac52187" wrote in message
...
I wish to combine text "ABCD" from first cell with "123" from other cell
and "XYZ" from third cell to display as "ABCD 000123; XYZ"
Can somebody help?

combine text and number with preceeding zeroes
 

=A1&" "&TEXT(B1,"0000")&" "&C1

Vaya con Dios,
Chuck, CABGx3


"mac52187" wrote in message
...
Thanks for the reply Paul. But the problem is
I used CONCATENATE(A1," ",B1,"; ",C1) Where B1 is formatted as"000000"
the problem is that the result is ABCD 123; XYZ Where as is need it to be
ABCD 000123; XYZ.( here 123 can be any 6 digit number with preceeding
zeroes)

combine text and number with preceeding zeroes
 

Sorry mac.............

Some musta got lost in the translation............
=A1&" "&TEXT(B1,"000000")&"; "&C1

Vaya con Dios,
Chuck, CABGx3



"CLR" wrote in message
...
=A1&" "&TEXT(B1,"0000")&" "&C1

Vaya con Dios,
Chuck, CABGx3


"mac52187" wrote in message
...
Thanks for the reply Paul. But the problem is
I used CONCATENATE(A1," ",B1,"; ",C1) Where B1 is formatted as"000000"
the problem is that the result is ABCD 123; XYZ Where as is need it to
be
ABCD 000123; XYZ.( here 123 can be any 6 digit number with preceeding
zeroes)