Wednesday, January 21, 2009

Changing CAPS to lowercase in EXCELL

The =PROPER() function will do this for most records.

Let's say your data is in A2:G600
Over in blank columns off to the right, enter a formula of =PROPER(A2)
Copy this formula from, say H2 to H2:N600. Make the shape of this range of formulas match the shape of your original range. If you original data has 7 columns, make this data have 7 columns.

You then have to change the formulas to values using these steps:
Highlight your range of formulas - H2:N600
Edit > Copy
Edit > Paste Special > Click Values > Click OK