See more Excel demos at a class="link" rel="nofollow" href=" br Storing information, such as a full address, in one column can limit what you can do with that information. For example, you can't easily filter or sort by part of the address, such as countryregion or city. However, if you break up the address into its parts — street address, city, stateprovince, postal code, countryregion — one for each column, you can remove those limits.