title: Extracting city and state info out of zip codes in Excel
body: <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>