Excel’s UPPER function has your back ... The format the email labels use is upper case. With UPPER, you can quickly turn john doe into JOHN DOE. When converting entire ranges to upper case ...