Excel’s UPPER function has your back. Syntax: =UPPER(text) This function takes one argument—the text you want to convert. You ...
There are two other methods to use the DEC2BIN function in Excel. 1] Click the fx button ... A Function Arguments dialog box will open. In the Number section, input 1 into the box.
To use the BIN2HEX function ... Excel. Create a table with headings Binary and Hex, or use an existing one. Under the hex heading type =BIN2HEX(A2,5). A2 is the Binary number you want to convert.