sponsored ads

how to convert big letter to small letter in ms excel

sponsored ads

The letter is too big. Do u know how to convert big letter to small letter in ms excel? who can give me some tutorials about it?
thanks Asked Mar, 09 2011
add commentflag 

sponsored ads

answer this question

Example:
cell A1: MINERVA
cell B1, type this =LOWER(A1)
will result minerva in B1

cell C1, type this =UPPER(B1)
will result MINERVA in C1

cell D1, type this =PROPER(C1)
will result Minerva in cell D1

Hope this helps and Good luck.

Answered Sep, 23 2010
vote up 0 vote down

You can use "=LOWER(TEXT)", it will convert the text into small letters, which is in capital letters in Ms Excel.

Hope it can be help for you~ Answered Dec, 26 2010
vote up 1 vote down

Try Format, Change Case or Shift+F3 to toggle between options. Also on Format Fonts, Small Caps give you the Large Capital and the rest of the word in Small Capitals. Depending on the effect you are after. Answered Dec, 15 2010
vote up 0 vote down

Your Answer

community wiki:

The Verified Code is to stop spamming. It will be hidden once your reputation reached 100.
or
Create one

Options

sponsored ads

Download related software from AFC

RAC1 to the letter 1.3

Last Updated: Jul 4, 2011
License:
Filesize: 131KB

Continue to downloadPower by Afreecodec.com