format a text cell in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

HowGirl - 03 Jan 2005 00:15 GMT

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

Reply to this Message

Nick Hodge - 03 Jan 2005 09:21 GMT

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)

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

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

Reply to this Message

HowGirl - 03 Jan 2005 19:13 GMT

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
[quoted text clipped - 3 lines]
> > Is there a way to format cells in Excell to automatically capitalize the
> > first letter of text in a cell?

Reply to this Message

BOB - 16 Jun 2005 22:54 GMT

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!

Reply to this Message

Gord Dibben - 03 Jan 2005 17:54 GMT

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

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

Reply to this Message