Judul : How to Use Formulas UPPER, LOWER, and PROPER in Microsoft Excel [ Version English ]
link : How to Use Formulas UPPER, LOWER, and PROPER in Microsoft Excel [ Version English ]
How to Use Formulas UPPER, LOWER, and PROPER in Microsoft Excel [ Version English ]
Tutorial Using Formulas
UPPER, LOWER, and PROPER
With Microsoft Excel
If the applications are Mircosoft Word Change Case menu that serves to change the text to uppercase, small or great beginning, in Mircrosoft Excel is clearly the facility is not available, Now for the solution instead can use the formula UPPER, LOWER, and PROPER.
Some people wonders how can I fix it all, but quiet as word admin, in Excel there is nothing impossible, for that you refer to the tutorial below.
1. Formula UPPER
UPPER formula used to change (mengconversi) text into hurus large (uppercase). Writing (Syntax) UPPER formula is:
= UPPER (text)
Example Use Excel formulas UPPER
In Cell B2 enter the formula = UPPER (A2) result LEARN from tkes Learning
In Cell B3 enter the formula = UPPER (A3) result FORMULA of tkes formula
In Cell B4 enter the formula = UPPER (A4) result EXCEL of tkes eXcels
In Cell B5 enter the formula = UPPER (A5) the results of IT from tkes It
In Cell B6 enter the formula = UPPER (A6) result EASILY of tkes easy
2. Formula LOWER
LOWER formula used to transform (convert) text into hurus small) (lowercase). Writing (LOWER formula syntax is:
= LOWER (text)
Example Use Formulas Excel LOWER
In Cell B2 enter the formula = UPPER (A2) result learn from tkes Learning
In Cell B3 enter the formula = UPPER (A3) the result is a formula from tkes formula
In Cell B4 enter the formula = UPPER (A4) result excel from tkes eXcels
In Cell B5 enter the formula = UPPER (A5) the result was of tkes It
In Cell B6 enter the formula = UPPER (A6) the result is of tkes easy
3. Formula PROPER
PROPER formula is used to convert text into beginning with a capital letter. Writing (syntax) PROPER formula is:
= PROPER (text)
Example Use Formulas PROPER
In Cell B2 enter the formula = UPPER (A2) result Formulas Excel from tkes formula excel
In Cell B3 enter the formula = UPPER (A3) result Formulas Excel from tkes FORMULA EXCEL
In Cell B4 enter the formula = UPPER (A4) result Formulas Excel from tkes Excel formula
In Cell B5 enter the formula = UPPER (A5) result Formulas Excel from tkes Excel formula
In Cell B6 enter the formula = UPPER (A6) result Formulas Excel from tkes formula EXCEL
Well, as the saying admin, in Mircrosoft Excel nothing is impossible, all that can be done with Excel, we just do not know much about Microsoft Excel.
Demikianlah Artikel How to Use Formulas UPPER, LOWER, and PROPER in Microsoft Excel [ Version English ]
Sekianlah artikel How to Use Formulas UPPER, LOWER, and PROPER in Microsoft Excel [ Version English ] kali ini, mudah-mudahan bisa memberi manfaat untuk anda semua. baiklah, sampai jumpa di postingan artikel lainnya.
Anda sekarang membaca artikel How to Use Formulas UPPER, LOWER, and PROPER in Microsoft Excel [ Version English ] dengan alamat link https://belajaroffice2017.blogspot.com/2017/04/how-to-use-formulas-upper-lower-and_14.html
0 Response to " How to Use Formulas UPPER, LOWER, and PROPER in Microsoft Excel [ Version English ]"
Posting Komentar