how to change caps lock on an excel list?

Question

i have a list of names some in small caps and other in big i wanna put them all in the same type, how can i do it im using excel 2007

Answer 1

If you want to do it in proper case (first letter capitalized, the rest lowercase), then in a seperate column, enter the following function:

=proper(select the cell you want to change).



If you want them to be lower, then enter =lower(type or select the cell you want to change).



To apply it to the whole list, select the cell that you entered the first formula in and all of the cells beneath it, and hit CTRL+D, which copies the formula down to the other rows.



Then just cut or copy the data from the new column and right-click the top row of the original column, select "paste special," then select 'values.' Hit OK.

Answer 2

1

Answer 3

Caps Lock Converter

Answer 4

I also found it easier to cut and paste into MS Word.



1. Select entire column in Excel.

2. Open up Word document and paste.

3. Select all (CTRL+A), then hit SHIFT+F3 until proper format is achieved.

4. Copy, then go back to Excel and paste.

Answer 5

Hmmm... for me, the easiest way is actually to cut and paste it into word and use the Change Case feature in Word.



There is a formula to recreate single cells and change their case (=PROPER(A1)), but I don't know how to apply it to a whole list of cells.