Extracting city and state info out of zip codes in Excel : <p>I need to extract city and state info out of the zip codes in my Excel sheet.
I have an Excel sheet which has over 50 thousands of zip codes in a single column, I created another 2 columns next to it as City and State. </p>

<p>Is there any easy way or any common formula to find out corresponding city and state names with these zip codes and populate them in city and state columns?</p>

<p>Thanks..</p>
