# Make the First letter Capital

This is a discussion on Make the First letter Capital within the Excel Questions forums, part of the Question Forums category; This is probably a simple question, but I have searched the archives and cannot find the answer... How can I ...

1. This is probably a simple question, but I have searched the archives and cannot find the answer... How can I make the first letter of every work a capital letter?

Thanks for any help!

2. I believe you want to use the PROPER function.

If A1 contains "This is a test" then PROPER(A1) will return "This Is A Test"

http://asap-utilities.com

[ This Message was edited by: Aladin Akyurek on 2002-05-20 13:03 ]

4. Thanks!

5. Can I apply proper to an entire worksheet? Or do I have to put it in each cell?

6. On 2002-05-20 13:08, Yadlik wrote:
Can I apply proper to an entire worksheet? Or do I have to put it in each cell?
You could try putting this in the worksheet's code module :-

Private Sub Worksheet_Change(ByVal Target As Range)
Dim cell As Range
For Each cell In Target
If cell.HasFormula = False Then
cell.Value = StrConv(cell.Value, vbProperCase)
End If
Next cell
End Sub

[ This Message was edited by: ldry on 2002-05-20 17:21 ]

7. ## Re: Make the First letter Capital

Originally Posted by lenze
I believe you want to use the PROPER function.

If A1 contains "This is a test" then PROPER(A1) will return "This Is A Test"
Hi,

Have been using your answer and works great but when there is an apostrophe involved it capatalise's the result, example - that's the way i'm going but can't go - That'S The Way I'M Going But Can'T Go...

How do you fix that...

Jay

8. ## Re: Make the First letter Capital

Try something like this:

=SUBSTITUTE(PROPER(SUBSTITUTE(A1,"'","Q")),"q","'")

9. ## Re: Make the First letter Capital

Try something like this:

=SUBSTITUTE(PROPER(SUBSTITUTE(A1,"'","Q")),"q","'")
Cheers,

That works a treat ...

Jay

10. ## Re: Make the First letter Capital

Hello,

First time poster here.

I am looking to also get a capital for the first word and need to know a command.

I get XLS data and the words are in all capital. I use the =lower(**) command to get them all in lowercase. but what I want is to also have the first letter in the word to be in capital. What else do i need to achieve this.

Andrew

Page 1 of 3 123 Last

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•