Changing upper case to lower in Excel

[cherie30]

Is there a way I can change a spead sheet in excel from upper case to lower case?

 

[SkipVought]

Hi,

There are spreadsheet functions; UPPER, LOWER, PROPER.

But, like any function, they reference an external cell.

So, if you want to "convert" ALL the cells in a sheet, you will have to do it from another sheet, OR find an area on the original sheet (less than half the sheet) to put your functions in.

The alternative is to run a simple VBA routine like this

For each c in ActiveSheet.UsedRange
   c.Value = LCase(c.Value)
Next

hope this helps


Skip,
Skip@theofficeexperts.com

 

[bryanbayfield]

What do you mean by "Spredsheet" - every single cell value? That would need VBA.

If you're just after a formula to convert a cell value (say in cell A1) to uppercase, your formula is:

=UPPER("A1")

A similar function exists for lower case.