Thank you. This is great! For the first example, what if the string contains more than one 5 number text. Like the third line. I think it pulled part of the address not the zip. (Toronto one)
You're right! In cases where multiple five-digit numbers appear, we could refine the search by using context, such as matching ZIP codes based on their position or neighboring city names. Alternatively, we can implement index table by countries to double check it like we did before or manually select the correct ZIP code when there’s ambiguity (delete {0} and remove unneeded rows).
Here is my solution: docs.google.com/spreadsheets/d/1zuJC76Vk8TDLJIsRVdW0Us5aFB2Ob3nV/edit?usp=drive_link&ouid=108776671615330203341&rtpof=true&sd=true But you may also like to check all other solutions here: ruclips.net/user/redirect?event=video_description&redir_token=QUFFLUhqblBueXVFbnVYSjdtNTVRQnZDTjdPVTg5QTh1UXxBQ3Jtc0tsZm0xT1pkeEphNG1NSTZzdGNWeGgwUThPUDc0Z2NKOTk5aVI3V3UyaGg5RzMtVm9xMjBLbG0zVzdfR3VBREdHbS1PWGdHbU5pVTNlNmpaZnhCVlBIclBwUFRUTWZyUmZpaWEtV1lmQzdELVFMb3pqUQ&q=https%3A%2F%2Fwww.linkedin.com%2Fposts%2Fexcelbi_excel-challenge-problem-activity-7273184903851036672-wWOt%3FDshare%26Dmember_desktop&v=uavkR8RrNXo
![I.N "HALLUCINATION" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/n5B5q1Hwt_U/mqdefault.jpg)
👍❤
Wow. Thanks
Ur video r useful source of information. Kindly make more easy function
Thank you so much! Sure. I'm planning to create a Power Query Basics playlist and continue the 'Excel Basics' series.
Thank you. This is great! For the first example, what if the string contains more than one 5 number text. Like the third line. I think it pulled part of the address not the zip. (Toronto one)
You're right! In cases where multiple five-digit numbers appear, we could refine the search by using context, such as matching ZIP codes based on their position or neighboring city names. Alternatively, we can implement index table by countries to double check it like we did before or manually select the correct ZIP code when there’s ambiguity (delete {0} and remove unneeded rows).
Kindly share source file with power query function.
Here is my solution: docs.google.com/spreadsheets/d/1zuJC76Vk8TDLJIsRVdW0Us5aFB2Ob3nV/edit?usp=drive_link&ouid=108776671615330203341&rtpof=true&sd=true
But you may also like to check all other solutions here: ruclips.net/user/redirect?event=video_description&redir_token=QUFFLUhqblBueXVFbnVYSjdtNTVRQnZDTjdPVTg5QTh1UXxBQ3Jtc0tsZm0xT1pkeEphNG1NSTZzdGNWeGgwUThPUDc0Z2NKOTk5aVI3V3UyaGg5RzMtVm9xMjBLbG0zVzdfR3VBREdHbS1PWGdHbU5pVTNlNmpaZnhCVlBIclBwUFRUTWZyUmZpaWEtV1lmQzdELVFMb3pqUQ&q=https%3A%2F%2Fwww.linkedin.com%2Fposts%2Fexcelbi_excel-challenge-problem-activity-7273184903851036672-wWOt%3FDshare%26Dmember_desktop&v=uavkR8RrNXo