1. I'm fairly new to Excel, I have one spreadsheet that already has Bar codes but it only excepts upper case letters, I don't know how to change the formula to …