Forum Discussion
excel -
how to parse data in a field i.e. field contains: address, city and zip code - i want to isolate ZIP code in a new cell
Hello Mike3812,
If you have Excel 2013 or later, you may flash fill the Zip Codes. See how to use flash fill here:
https://support.office.com/en-us/article/using-flash-fill-in-excel-3f9bcf1e-db93-4890-94a0-1578341f73f7
If the Zip Codes are always the last 5 characters in each field, then that could be the following formula:
=RIGHT(Text, 5)