Is there a way to check if a Canadian postal code is in the correct format?
I have mailing addresses within a file and I'm trying to check the postal codes to ensure they follow the right format of A#A #A#. With Excel, I'd use the MID formula to return the specific character and manually review. Is there a Power Query function to check the format of postal codes and ensure they follow the guidelines of A#A #A#?
Thank you in advance! I've tried searching for this but couldn't find any solutions.