Unlike Microsoft Word, Microsoft Excel does not
have the Change button to change the letter capitalization capitalization.
However, you can use the function UPPER, LOWER, or RIGHT to automatically
change the case of existing text letters to uppercase, lowercase, or
capitalized letters. Functions that only the default formula that is designed
to accomplish specific tasks-in this case, change the case of text letters.
Function to change
the font (change case) in Microsoft Excel are as follows :
LOWER - to turn all
capitals on the text to lowercase.
Example: ade, susi,
ammy, rob or favor
UPPER - to change
all lowercase text to uppercase.
Example: ADE, SUSI,
Ammy, RUDI or BUDI
PROPER - to make
the first letter of text to uppercase and the other letters to lowercase.
Example:
Ade, Susi, Ammy, Rudi or Budi
In the example below, the PROPER function is used
to rename the capital letters in column A to the correct letter capitalization,
which makes capital letters for the first letter in each name.
1. First, insert the column while next to the columns
that contain the text that you want to convert. The formula to convert the name
in cell A8 of lowercase letters changed to capital front. In this case, I have
added a new column (B) on the right column of customer names.
In cell B8, type = PROPER(A8), exactly as shown
below, and then press ENTER.
After B8 turn into big letters on the front, please
copy and paste it into the B8 B9 to B14.
After the buddy move the names that have been
converted earlier from B8 to B14 to the A8 to A14 by way of block B8 to B14
Then copy. Paste in the A8 to A14 with its value Paste Special and then click
OK, remove B8 to B14. If it is enough, its B cells in the clear. Then the
result can be seen in the picture below.
2. To convert text to uppercase process is no
different to the above, ikutu measures such as the above. But for cases like
this, use =UPPER(A8) where my friend need to change the text to uppercase,
replacing the A8 with the corresponding cell reference.
3. And to change the letter from big to small letters
using =LOWER (A8), the next step together with the steps above.
Thus tutorial
change the font in Microsoft Excel, may be useful. Do not forget to criticism
and advice awaited. For more details, my friend can see the video below.
AsBoed'80
No comments:
Post a Comment