View Single Post
  #5  
Old 13th July 2006, 09:40 AM
jfc jfc is offline
Member
 
Join Date: Jan 1970
Location: Sydney
Posts: 402
Default

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 ")
Reply With Quote