Excel - change the Upper and Lower value (solved)

Dear all,

Hope you all fine.

One of my friend ask this to me. Thats why i sharing this. It may useful!!!

If you wnat to change the Cell Value into Upper and Lower without edting the Cell Value.

For Eg.,

Change the Upper Value:
If you want to change the Name "john" (A1 Cell) into "JOHN".

Just using the Formula, =Upper(A1) and click the Enter. All the words Changed to UPPER.

Change the Lower Value:
If you want to change the Name "JOHN" (B1 Cell) into "john".

Just using the Formula, =Lower(B1) and click the Enter. All the words Changed to LOWER.

Thats all.

Warm Regards,
Mani.V