How to Change from Lowercase to Uppercase, Uppercase to Lowercase in Excel , Change text to upper, lower, or proper (Normal) font
How to Change from Lowercase to Uppercase & Uppercase to Lowercase in Excel
माइक्रोसॉफ्ट के एक्सेल स्प्रेडशीट प्रोग्राम अपना पाठ को सुसंगत बनाने के लिए है। आप उचित (PROPER ), बड़ा (Upper) और छोटा (Lower) में लिखने के लिए निम्नलिखित फार्मूला का प्रयोग कर सकते है |
जैसे की -WeLcome To CGdarpan → Welcome To Cgdarpan, welcome to cgdarpan, WELCOME TO CGDARPAN
For example, column A has a list of names in lower case. Here's how you can change the names to proper case.
Proper - =PROPER(A1)
For example, column A has a list of names in lower case. Here's how you can change the names to upper case.
UPPER - =UPPER(A1)
For example, column A has a list of names in lower case. Here's how you can change the names to lower case.
lower - =LOWER(A1)
http://www.staffinfo.in/2016/06/fill-handle-display-or-hide-in-excel.html
ReplyDelete