i need to capitolize a column of names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

-via135
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lock a Cell as Capitols only 1
How do change a column of data in capitol letters to small letters 6
Need help making the first letter of Cell capitol 1
ms word 2007 part of letters missing 2
how turn off auto cap first word in sentence outlook 2007? 2
Searching two fields 3
Repeat Data 1
Outlook 2003 email first letter of line 7

Back
Top