format a text cell in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to format cells in Excell to automatically capitalize the
first letter of text in a cell?
 
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)
 
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
 
Thanks so much - this will work for me.

Nick Hodge said:
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)
Click to expand...
 
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!
 
Back
Top