HOW TO USE UPPER LOWER AND PROPER FUNCTION IN EXCEL


HOW TO USE UPPER LOWER AND PROPER FUNCTION IN EXCEL


UPPER CASE / UPPER FUNCTION IN EXCEL


UPPER FUNCTION IN EXCEL WWW.COURSEDOTS.COM

=upper(A2)

If you want to converted any text to uppercase. use UPPER function in excel.  upper function converted  any text in Capital letter or Uppercase letter. in this example, A2 text is in small letter. use the UPPER function in B2 to converted text in Uppercase / Capital Letter. 

LOWERCASE / LOWER FUNCTION IN EXCEL 


LOWER FUNCTION IN EXCEL WWW.COURSEDOTS.COM

=lower(A10)

if you want to convert all letter in the cell string small case or small letter in excel. Use LOWER function to converted. In this example cell A14 text "KARACHI123" is the upper case after using LOWER function in Cell B14 text converted in a small case like "karachi123".


PROPER FUNCTION USE IN EXCEL



PROPER CASE IN EXCEL WWW.COURSEDOTS.COM

=proper(A18)

if you want to convert all letter in the cell string proper case or proper letter in excel. Use "PROPER" function to converted the first letter of each word in upper case and all other words in lowercase.


 Download Sample File Click Here 

you have any idea about Excel, blogger., WordPress, photoshop, Seo Experts, other like this simply create your own article and submit your own post. your post will publish as soon on www.coursedots.com


EmoticonEmoticon