This example teaches you how to convert a text string to lower, upper or proper case in Excel.
1. Use the LOWER function to convert all letters in a text string to lowercase.

2. Use the UPPER function to convert all letters in a text string to uppercase.
Upper Function in Excel
3. Use the PROPER function to convert a text string to proper case. That is, the first letter in each word in uppercase, and all other letters in lowercase.
Proper Function in Excel
30 Jan 2014

0 comments:

Post a Comment

:) :)) ;(( :-) =)) ;( ;-( :d :-d @-) :p :o :>) (o) [-( :-? (p) :-s (m) 8-) :-t :-b b-( :-# =p~ $-) (b) (f) x-) (k) (h) (c) cheer
Click to see the code!
To insert emoticon you must added at least one space before the code.

 
Top