Lettters

[Chi]

Hi,

The Last name column has uppercase and lowercase letters.
I would like to make them become all uppercase letters.(
First letter, not whole word)

Ex: Huynh
tran
Nguyen
hong

I would like them to be: Huynh
Tran
Nguyen
Hong

 

[Patti]

Will this work?

=Proper(A1)
and copy down

Where the names you want to change are in column A

 

[JE McGimpsey]

Check out

http://www.mvps.org/dmcritchie/excel/proper.htm

If you're not familiar with macros, see

http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Rojee]

Hello

use

=proper(A1)

this will capitalize the first letter in each word