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