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