Hi Formula to assign letters to digits and repeatedly sum to a single digit kindly see attached example excel file in zip format Regards Jp