Twodogs
16th May 2007, 07:16 PM
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
jfc
17th May 2007, 03:26 AM
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))
Twodogs
17th May 2007, 05:16 AM
Thanks JFC
Much appreciated!!
Twodogs
vBulletin v3.0.3, Copyright ©2000-2025, Jelsoft Enterprises Ltd.