This post describes free and ready to use Excel/VBA functions for IBAN validation, based on Mod 97 calculation and a format check of the country-specific Basic Bank Account Number (BBAN).