format a text cell in Excel

[Guest]

Is there a way to format cells in Excell to automatically capitalize the
first letter of text in a cell?

 

[Nick Hodge]

For data in A1, enter this in B1 and then copy and paste special the data
back to column A to replace it

=PROPER(A1)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Gord Dibben]

HowGirl

No way to format as such.

Would need event code behind the worksheet. The code below operates on cells
in columns A through H. Note the "8" which is column H. Adjust to suit.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column > 8 Then Exit Sub
On Error GoTo ErrHandler
Application.EnableEvents = False
Target.Formula = Application.Proper(Target.Formula)
ErrHandler:
Application.EnableEvents = True
End Sub

Right-click on the sheet tab and "View Code". Copy/paste the code in that
sheet module.


Gord Dibben Excel MVP

 

[Guest]

Thanks so much - this will work for me.

For data in A1, enter this in B1 and then copy and paste special the data
back to column A to replace it

=PROPER(A1)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Guest]

Thank you so very much! Couldn't figure out how to use this function with
the Microsoft help (kept getting circular reference) your response indicated
how to prevent that!