Title case for text in columns

A

Annalise Vogel

Hi formatting gurus,

How can you apply title case to text in columns in excel??

Please help.

Annalise
 
G

Gord Dibben

Use the PROPER Function

=PROPER(cellref) and drag/copy

To speed up the process a bit you can select a blank range the size of your
data range and array-enter this formula.

i.e your data range is columns A1:E100

Select F1:J100

In active cell enter =PROPER(A1:E100) hit CTRL + SHIFT + ENTER


Gord Dibben Excel MVP
 
R

Ron Coderre

If I understand you correctly, try this:
In a convenient column and for text in A2:
B2: =PROPER(A2)
Copy that formula down.

That would change "ron coderre" into "Ron Coderre".

Then you might want to:
Select the formula column
Edit>Copy
Select A2
Edit>Paste Special>Values

Does that help?

***********
Regards,
Ron
 
D

David McRitchie

Hi Annalise,
The only way you can apply Title Case (or Proper Case) to the
same column is with a macro. Take a look at
http://www.mvps.org/dmcritchie/excel/proper.htm
also using a macro allows you to customize your results, because
not all words should have first letter actually capitalized.
Once Upon a Time
David McRitchie
Also use of a macro means you make a selection and invoke the
macro, you don't have to worry about extending a formula past
your data or not including all of your data in a column.
 
Top