I have mailing address in column a and actura address in column b I want to
compare a1 to b1, a2 to b2, and etc. I would need to condition it on the
first 8 or 9 characters as the mailing address has ST< AVE< BLVD etc and the
actual does not.

If they match I want to move the info from A to a new column If they do not
match I wnat the new column row to be blank