PDA

View Full Version : Excel Formula Help Please


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