How do I change case in Excel?

QABoy · 1 Dec 2006 at 08:07

I've been on holiday for a week and the bloke who's done my job has filled our workshheets with SHOUTING. I thought it would have been a simple process of highlighting all the words, going to the menu and clicking on Change Case like in Word but I can't find anything. Any idea how I do it?

QABoy · 1 Dec 2006 at 08:47

Grief

I thought it would be a simple process of choosing about a 1000 cells and clicking on a button that says lower case.

QABoy · 1 Dec 2006 at 11:15

Thanks for that but typing anything in another cell buggers things up all over the sheet. (every cell is counted).

QABoy · 2 Dec 2006 at 10:10

madmaxx said:
Surely the simple solution is to highlight all the cells with SHOUTING in them, paste them into a blank Word Document, and whilst they are highlighted go Format, Change Case. Then select lower case, and viola, you have a number of cells containing lower case writing. Then, with them still highlighted, copy, and go back into Excel, and paste them back over the top of the source cells. Sorted - I've just tried it with a spreadsheet here, and it seems to work ok.
Hope that helps.

That worked, thanks.