Changing case

  • Thread starter Thread starter Tony Winyard
  • Start date Start date
T

Tony Winyard

Is there any easy way of changing the case on a column in
a worksheet to "Sentence Case"
 
Thanks for the reply which is no doubt very useful to
someone who is at a more advanced level of using Excel,
but i am certainly not, so could anyone possibly explain
if there is an easy way of changing the case in a column
to Sentence Case.
 
Tony,
If Frank's simple answer is meaningless to you then you should consider
starting with a book on Excel.
Frank is telling you to use Help to learn how the function named PROPER
works!
best wishes
Bernard
 
Hi Tony,

For what it's worth:
Tushar Mehta has a macro for converting to sentence case.
The macro code is available at (it is noted in related area of proper.htm)
http://google.com/[email protected]

Actually what Frank provided was Proper or Title case.
See Spot Run. Run Spot Run.
Sentence case would be (not correcting for Spot as a proper name)
See spot run. Run spot run.

As a worksheet function, you need another cell (like another column)
A1: see spot run
B1: =PROPER(A1)
and you can copy the formula down with the fill handle
http://www.mvps.org/dmcritchie/excel/fillhand.htm

which is described in your HELP ....

F1 (function key F1), Index, PROPER Worksheet Function
if you are unlucky enough to have Excel 2003
you could type the above into the Answer Wizard
(or maybe they call that Search).

There is no worksheet function for Sentence Case you would
need a macro or a user defined function (UDF).

To change the data in place you would need a macro.

More information on all of the above can be found in
Proper, and other Text changes -- Use of SpecialCells
http://www.mvps.org/dmcritchie/excel/proper.htm

To get you started, I would suggest you start out with some
of the Excel tutorials, most of what I link to on my pages
are designed for university students without regard to major
or prior experience so I think they are very generalized to start with.
In other words when you buy a book, buy a book you can use
as a reference not one that wastes several chapters on getting
started.
http://www.mvps.org/dmcritchie/excel/excel.htm#tutorials
 
Tony

Which do want? Sentence case is like this with just first word Upper Case.

Proper Case Is Like This.......also known as Title Case

You can achieve Proper Case using the PROPER function in Excel.

Assume text is in column A.

In Column B at B1 enter =PROPER(A1)

Darg/copy this down Column B as far as you wish or just double-click on the
fill handle(black square at bottom right corner of B1)

Sentence Case would require VBA coding.

Gord Dibben Excel MVP
 
Back
Top