7th August 2006, 07:56 PM
|
|
Member
|
|
Join Date: Jan 1970
Location: Sydney
Posts: 402
|
|
Quote:
|
Originally Posted by Twodogs
Okay no problems on the max distance doing what you suggested but on the min distance it tells me there are too many arguments. Not sure what to eliminate.
I have attached my progress
Twodogs
|
=IF(LEN(A2)>3,VALUE(SUBSTITUTE(MID(A2,1+FIND("(",A2),4),")","")),0) |