OZmium Sports Betting and Horse Racing Forums

16th May 2007, 07:16 PM

Twodogs

Member

Join Date: Jan 1970

Posts: 221

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

17th May 2007, 03:26 AM

jfc

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

17th May 2007, 05:16 AM

Twodogs

Member

Join Date: Jan 1970

Posts: 221

Thanks JFC

Much appreciated!!

Twodogs

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is On

All times are GMT +10. The time now is 02:47 AM.

	To advertise on these forums, e-mail us.