17th May 2007, 03:26 AM
|
|
Member
|
|
Join Date: Jan 1970
Location: Sydney
Posts: 402
|
|
Quote:
|
Originally Posted by Twodogs
Can anyone give me an idea of how I can take 3 columns of numbers and put them into one column like this 10-8-1?
Thanks
Twodogs
|
=CONCATENATE(TEXT(A1,0),"-",TEXT(B1,0),"-",TEXT(C1,0)) |