Title case for text in columns

[Annalise Vogel]

Hi formatting gurus,

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

Please help.

Annalise

 

[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

 

[Guest]

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

 

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