Make the First letter Capital

[Yadlik]

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!

[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"

[Aladin Akyurek]

In addition, you could use ASAP-utilities, a free download from:

http://asap-utilities.com


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

[Yadlik]

Thanks!

[Yadlik]

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

[ldry]

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 ]

[Benby]

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

[btadams]

Try something like this:

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

[Benby]

Originally Posted by btadams

Try something like this:

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

Cheers,

That works a treat ...

Jay

[ballabooyeah]

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.

Thanks in advance.

Andrew