I have a column of information that is in all caps. I would like to copy the
same information to a new column. In the new column I want it to be lower
case except for the first letter of the cell. (They are names and the first
and last names are separated in different cells). I only need to do this
once, but some automation would be helpful because it is about 800 rows of
data.

Thanks,
Scott

just use
=proper(a1)
copy downcopypaste values

--
Don Guillett
SalesAid Software

"S.E." wrote in message
...
I have a column of information that is in all caps. I would like to copy
the
same information to a new column. In the new column I want it to be lower
case except for the first letter of the cell. (They are names and the
first
and last names are separated in different cells). I only need to do this
once, but some automation would be helpful because it is about 800 rows of
data.

Thanks,
Scott

Hi
see:
http://www.cpearson.com/excel/case.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"S.E." schrieb im Newsbeitrag
...
I have a column of information that is in all caps. I would like to
copy the
same information to a new column. In the new column I want it to be
lower
case except for the first letter of the cell. (They are names and the
first
and last names are separated in different cells). I only need to do
this
once, but some automation would be helpful because it is about 800
rows of
data.

Thanks,
Scott