Good Evening

Wondering what is possible? I have a column with winning dist data as follows
1(1300) 1(2050) 1(2500) 1(3050) 1(3200)

What I would like to be able to do is have a formula which would give the winning distance range like this 1300-3200 in an alternative column.

Thanks
Twodogs

=CONCATENATE(SUBSTITUTE(MID(A1,1+FIND("(",A1),4),")","")," - ",SUBSTITUTE(LEFT(RIGHT(A1,5),4),"(",""))

Thanks JFC

Works a treat!!! Don't for a moment understand it but all I can say is you beauty!!

Twodogs

ps what would be needed when there is no data in the column due to no winning distances to return a a zero rather than "value"

Hi JFC

Can I overcome the fact that when the column with winning distances is empty due to no winning distance I get a "value" error or would I need to look at the column with the winning distances and do something with that data first before applying your formula.

Thanks
Twodogs

=IF(LEN(A1)>3,CONCATENATE(SUBSTITUTE(MID(A1,1+FIND("(",A1),4),")","")," - ",SUBSTITUTE(LEFT(RIGHT(A1,5),4),"(",""))," 0 ")

Thanks JFC,

Your time and help is much appreciated.

Twodogs