OZmium Sports Betting and Horse Racing Forums

OZmium Sports Betting and Horse Racing Forums (http://forums.ozmium.com.au/index.php)

- Horse Race Betting Systems (http://forums.ozmium.com.au/forumdisplay.php?f=10)

- - Excel Formula Help Please (http://forums.ozmium.com.au/showthread.php?t=15896)

Twodogs

16th May 2007 07:16 PM

Excel Formula Help Please

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

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

Twodogs

17th May 2007 05:16 AM

Thanks JFC

Much appreciated!!

Twodogs

All times are GMT +10. The time now is 12:07 AM.