I thought just copy and paste is enough.
Anyway, when paste, use paste special instead of just paste.... select unicode then.
for Distance wise, make some extra column and use =value(substitute(xxx,"NM","")) . Voila!, it is now distance in number variable type. Otherwise, sorting a text string cell would return order of 9xx nm after 8xxx nm.