I have a file of names and addresses which has an ID no some of which are numeric only and some of which have a single alpha character as a prefix. Those with the prefix were APPENDED to those with the numeric ID.

Now when I try to filter in EXCEL I find that the filter only lists those numeric IDs. I know that the records with prefixed IDs are there.

Can anyone enlighten me?

Steve McG