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