Is there a way to validate a list of addresses in Excel that is free of charge? I have a list of addresses that were put in by various individuals that I would like to standardize. For example, I would like to change all of the states that are spelled out to state abbreviations. I would like to take the words Street, Drive, Avenue, etc and convert them to abbreviations as well. I would also like to convert all the addresses to all upper case. Does anyone know of a way to accomplish this without having to pay a monthly fee or a fee per address?