Hi again Paul,

I've noticed that there is an occasional address that has information such as a suite description after the zip

Example:
ANAHEIM, CA 92806 UNIT E & F

Would it be much for you to adjust the code to take that into account?

Result should be:
ANAHEIM, CA UNIT E & F in Column A and the Zip put into Column B (same as the code does now)

Thanks