hi thanks for the reply
i have resolved the issue as was making things more awkerd for myself i changed
sDistance = Mid(sDistance, lTopicstart + 6, lTopicend - lTopicstart - 6)
to
sDistance = Mid(sDistance, lTopicstart + 6, lTopicend - lTopicstart - 8)
this removes the mi at the end of...