Here we are using upper case formula, these formula are used in advanced excel.
| A | B | C | |
| 1 | Hansraj | HANSRAJ | =upper(TEXT) =UPPER(B1) |
| 2 | lakir | LAKIR | =UPPER(B2) |
| 3 | Seema | SEEMA | =UPPER(B3) |
| 4 | Mansi | MANSI | =UPPER(B4) |
| 5 | jyoti | JYOTI | =UPPER(B5) |
| 6 | mahima | MAHIMA | =UPPER(B6) |
| 7 | shashi | SHASHI | =UPPER(B7) |
0