Capitalize the first letter

  • Thread starter Thread starter Chi
  • Start date Start date
C

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
.----------------------------------------------
Click to expand...
I got the reply is "

use

=proper(A1)

this will capitalize the first letter in each word"

---------------------------
I am not sure what to do.
Please tell me more detail.

I need select whole column or ......change format????
Thank you
Chi
 
Hi Chi,
You will need to insert a helper column. Assuming that
your data is in column A you will need to put the formula
in your helper column, copy it down the length of column
A's data, then copy the new values that you get in your
helper column and paste the values over those in column A.
 
if you have Huynh tran Nguyen hong in cell A1, put the formul
'=proper(A1)' in cell B1. it will give you Huynh Tran Nguyen Hong i
cell B1
 
Chi,

Open Excel, Go to Help and type in Proper. It will give you an excellent
explanation of what it does


:
:
: >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
: >.----------------------------------------------
: >
: I got the reply is "
:
: use
:
: =proper(A1)
:
: this will capitalize the first letter in each word"
:
: ---------------------------
: I am not sure what to do.
: Please tell me more detail.
:
: I need select whole column or ......change format????
: Thank you
: Chi
:
:
:
 
If your lastnames can be multiple words and you want only the first letter of
the first word uppercase--and all the other letters lower case:

=upper(left(a1,1))&lower(mid(a1,2,999))

(make 999 big enough to include all the letters. But I bet it already is!)
 
use the formula =proper(A1)
-----Original Message-----


I got the reply is "

use

=proper(A1)

this will capitalize the first letter in each word"

---------------------------
I am not sure what to do.
Please tell me more detail.

I need select whole column or ......change format????
Thank you
Chi



.
Click to expand...
 
Back
Top