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).

" 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

hi!

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

-via135


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


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=536979