How to convert capital letters to small letters in MS excel?

Answer Though you could use the LOWER function in a formula, that does not do much good when you wish to convert the text in a large number of cells on a spreadsheet to lowercase. A better approach is to... Read More »

Top Q&A For: How to convert capital letters to small letters...

Does anyone know how to convert a Excel spreadsheet form all cap letters to proper letters?

If this was MS-Access, then a simple Query could handle this in a matter of seconds.But you will need to have a VBA coded Macro established to search through your worksheet and modify the cells to ... Read More »

Converting Small letters to capitals in a Large Excel Document?

You can either use a formula to produce the result you want, or add in some VBA code to use as a Macro to execute. We will start off with the first option: If column B needs to be uppercase, then ... Read More »

If i type a bunch of words with only capital letters how do I change these words to lowercase letters?

it depend what programme you used, in microsoft office word which i use there is an icon for this. if the document is not too long you can backspace each letter and substitute it's lower case equiv... Read More »

Why do some people still insist on typing everything in CAPITAL LETTERS?