Assume cell A1 = "123", B1= "345", and C1="0145"
This expression =CONCATENATE(A1&" "&B1&" "&C1) in another cell will render
"123 345 0145"
--
C G Barton


"Sharon Barr" wrote:

I have a large spreadsheet where the phone number is split into three
columns. I want to combine these three columns into one and format as a phone
number. Also, the last column is dropping leading zero. I need it to keep the
leading zero.