Converting a column of cells to change the text to be capitalized.

[Guest]

I have a user who has a column of names, which are currently all typed in lowercase. It is necessary to have all this data in capital letters. Is it possible to have excel automatically convert all the names in that column to capital letters, without having to type each name over again. Thanks, any help is appreciated.

 

[Norman Harker]

Hi Clayton!

If they are all names:

Insert a column to the right
Use:
=UPPER(A1) [Or whatever is the first cell to the left]
Copy down

Select the new data
Copy
Edit > Paste Special > Values
Delete the old data

But I really don't know what I hate most; all upper case or all lower
case.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Gord Dibben]

Perhaps =PROPER(A1) would be better for names.

Gord Dibben Excel MVP

 

[Norman Harker]

Hi Gord!

Too right! That's wat I woz teeched wen i woz tort too rite.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.