Make the First letter Capital

Yadlik

New Member
Joined
May 8, 2002
Messages
40
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!
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
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"
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
Try something like this:

=SUBSTITUTE(PROPER(SUBSTITUTE(A1,"'","Q")),"q","'")
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,501
Messages
6,114,010
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top