I have this thing with excel, I'm trying to do. I have a long list ( about
6000 entries) for locations along with their latitudes and longitudes. I
have these input as text (they are numbers) with no separations. They all
however, have the same format, from right to left, first two digits are
seconds, next two digits are minutes, and all other digits are degrees. (can
be two or three digits) Now what I'm trying to do, is to find some way to
sort these guys, or filter them, so that I can see places that are withing
say five minutes of a certain set of coordinates. So if for example I have
254935 and 1090006, it would find me everythin within say 254400:255400 and
1089500:1090506.

Is this possible?

Thanks