i need to capitolize a column of names

i have a column of 6000 names that are not capitolized and i need to be able
to capitolize the text with out haveing to manually go through each one, is
there a way to format this?? thanks

hi!

assuming that the names are in A1:A6000, enter
in B1: =UPPER(A1) and fill down upto B6000

-via135

Originally Posted by lml9876@hotmail.com

i have a column of 6000 names that are not capitolized and i need to be able
to capitolize the text with out haveing to manually go through each one, is
there a way to format this?? thanks

Use the UPPER function. First, create a new blank column to the right of
your column of names (if your names are in column A, create a blank Column
B). Beginning in Cell B1, type =UPPER(A1). Now copy down as far as needed.
(Alternately, select Column B and click Ctrl+D to copy down.) Finally Copy
Column B, and Edit > Paste Special, Value over Column B (to remove the
formula). You can now delete the original column of names (Column A).

"lml9876@hotmail.com" wrote:

> i have a column of 6000 names that are not capitolized and i need to be able
> to capitolize the text with out haveing to manually go through each one, is
> there a way to format this?? thanks