13th July 2006, 05:09 AM
|
|
Member
|
|
Join Date: Jan 1970
Location: Sydney
Posts: 402
|
|
Quote:
|
Originally Posted by Twodogs
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),"(","")) |