Using Excel 2003. Have downloaded info and it was downloaded in all caps.
Have tried to use the =PROPER formulat but it doesn't work. If I go to a
separate cell in the spreadsheet referencing a specific cell it works. How
can I change in one worksheet all caps to PROPER ?

I don't understand why =PROPER wouldn't work!

You can copy this code to your personal.xls file and run it

Sub TextProper()
Dim ttt As String
Dim c As Object

For Each c In Selection.Cells
ttt = c.Value
c.Formula = Application.Proper(ttt)
Next
End Sub

Have a great day,
Francis Hayes (The Excel Addict)
http://www.TheExcelAddict.com



"Snowcap" wrote:

Using Excel 2003. Have downloaded info and it was downloaded in all caps.
Have tried to use the =PROPER formulat but it doesn't work. If I go to a
separate cell in the spreadsheet referencing a specific cell it works. How
can I change in one worksheet all caps to PROPER ?

Francis - thanks for responding so quickly. I have signed up for your
newsletter. I'm pretty much a novice so I really don't know how to do what
your suggesting. Can you help me on how to do this.
Thanks!

Gary Hunt

"Francis Hayes (The Excel Addict)" wrote:

I don't understand why =PROPER wouldn't work!

You can copy this code to your personal.xls file and run it

Sub TextProper()
Dim ttt As String
Dim c As Object

For Each c In Selection.Cells
ttt = c.Value
c.Formula = Application.Proper(ttt)
Next
End Sub

Have a great day,
Francis Hayes (The Excel Addict)
http://www.TheExcelAddict.com



"Snowcap" wrote:

Using Excel 2003. Have downloaded info and it was downloaded in all caps.
Have tried to use the =PROPER formulat but it doesn't work. If I go to a
separate cell in the spreadsheet referencing a specific cell it works. How
can I change in one worksheet all caps to PROPER ?