amsnss,

Lets take another look at Column A. Is the sample pretty much what you will be work with everytime. In other words will you always have the heading

Policy
Number
-------------------

We might be able to work with that.

Do the policy numbers have a minimum and a maximum length. Do they always begin with a letter or a number? Do they always end with a letter or a number?

We can have multiple things that we look at, but we still need to know what those multiple things are.

If you can provide a few more details, I'll be more than happy to continue helping you move towards a solution.