TL;DR: need to generate single-use voucher codes (with embedded representative ID and expiration date?) No programmers are available, so it's just me, and I know Excel. Our small business is talking ...
Use Power Query's M language to quickly fix names, remove hidden characters, extract numbers, and merge columns.