As long as the format is consistent:

n<spacekm
n<spacekm
n<spacekm

=SUMPRODUCT(--(SUBSTITUTE(A1:A3," km","")))

Think the formula works even if the format is
n<spacekm
nkm
n<spacekm

=SUMPRODUCT(--(SUBSTITUTE(A1:A3,"km","")))

if we put it as "km", instead of " km"
(a subtle difference <g)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---