Hello everyone
i want to convert text in exle file from lower case to all caps
can anyone help me
Aneesh Rana
Hello everyone
i want to convert text in exle file from lower case to all caps
can anyone help me
Aneesh Rana
Rana ji
u can do like this, suppose u want to convert the text written in cell K34
1. slect a empty cell somwhere on same sheet suppose F12
2. enter in this cell- =UPPER(K34) and enter
3. Copy this cell F12
4. paste spl in K34 (use values option during paste spl)
5. Delete the text in F12
I am not a computer expert, there may be short cut for this, since there was rescue for u from our computer geeks. so use above till u get something short and let me know if u find better way.
The never-ending task : Self Improvement