Making First Letter Of A Text In Upper Case

[arjcvg]

Hi Guys!

I just wanna ask, for example i have a text like this:

millar, donne

How will I make this like

Millar, Donne

Thanks for your usual help

 

[duane]

if your text is in cell a4

=UPPER(LEFT(A4,1))&RIGHT(A4,LEN(A4)-1

 

[duane]

sorry - misread your question....more work neede

 

[Biff]

one way:

=PROPER(A1)

Biff

 

[duane]

a touch more complicated.....name in cell a7

=UPPER(LEFT(A7,1))&RIGHT(LEFT(A7,SEARCH(" ",A7)-1),SEARCH(" ",A7)-2)&
"&UPPER(LEFT(RIGHT(A7,(LEN(A7)-SEARCH(
",A7))),1))&RIGHT(A7,LEN(A7)-SEARCH(" ",A7)-1

 

[Frank Kabel]

Hi
and why not use Proper?

 

[arjcvg]

Thanks Guys

 

[Don Guillett]

One way
Sub makeproper()
For Each c In Selection
c.Value = Application.Proper(c)
Next
End Sub

 

[M S-Greenaway]

Hi Mate

Use the PROPER function

Thanks

Mikey