change text case in excel

[daveonion]

Hi i have a spreadsheet in uppercase and i need it to be proper case i.e. first letter capital.
hope you can help thanks

Dave

 

[xlbo]

just use
=PROPER(A1)
where A1 contains uppercase text that you want to reformat Rgds
Geoff

Vah! Denuone Latine loquebar? Me ineptum. Interdum modo elabitur

 

[andrew299]

Can this be done in word????

 

[xlbo]

Well I don't think you can use a formula but you can select your text and go
Format>Change Case
and choose "Sentance Case"

HTH Rgds
Geoff

Vah! Denuone Latine loquebar? Me ineptum. Interdum modo elabitur

 

[daveonion]

where about do I insert proper, in the cell?

 

[xlbo]

If you have this:
THIS TEXT IS UPPERCASE
in cell A1, then in B1 (or another empty cell, enter
=PROPER(A1)
This will convert the above to:
This text is uppercase

Then you can copy the new cells
Select the old cells and use
Edit>Paste Special>Values Rgds
Geoff

Vah! Denuone Latine loquebar? Me ineptum. Interdum modo elabitur

 

[andrew299]

Thanks geoff

 

[daveonion]

Geoff is there a way of just going through thw whole spreadsheet and convert it automatically, a do while loop or something

regards
Dave

 

[xlbo]

Yup - but it's likely to take awhile:

Sub ChangeToProper()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
For Each c In ActiveSheet.UsedRange
c.Value = WorksheetFunction.Proper(c.Value)
Next c
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
End Sub Rgds
Geoff

Vah! Denuone Latine loquebar? Me ineptum. Interdum modo elabitur

 

[daveonion]

thanks geoff