Hello was wondering how to put numbers in 3 columns into the format 5:2-1 in one column.

Cheers
Twodogs

Have I got this right?

You want to put 5 2 1 into one cell looking like this 5:2-1?

If so, assume your data is in cells A1 B1 and C1.

Cell D1 enter formula =A1&":"&B1&"-"&C1

Result is 5:2-1

Just copy the formula all the way down Column D to do all of columns A B and C at once.

__________________
RaceCensus - powerful system testing software.
Now with over 426,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 31/10/2025
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg

Thanks Chrome,

That is way simpler to what I tried without success.

Cheers
Twodogs