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 »

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 »

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 »

How to Stop Letters from Erasing Other Letters While Typing?

Are you tired of accidentally hitting a key you don't know you hit and the letters on the screen keep on erasing every time you type something behind it? Well learn what key you hit and fix the pro... Read More »