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