Changing Font case in excel

[Guest]

Is there a way to to change upper case fonts to say, title case or lower case

Thanks in advance

Andrew

 

[Paul B]

Andrew, here is one way, with your data in A1

=PROPER(A1)

=LOWER(A1)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

 

[Norman Harker]

Hi Andrew!

See:

Dave McRitchie:
http://www.mvps.org/dmcritchie/excel/proper.htm#lower

There's code there that should handle whatever changes you want.

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

 

[Guest]

I do not quite follow on where and how to enter it?

 

[Guest]

Thanks I think I can get through it now

Andrew

 

[Guest]

I understand that the formula I want ot use is =PROPER(A2

BUT how do I use it?

 

[Dave Peterson]

If you're going to use the worksheet formula, you could insert a helper column
adjacent to the column that you want to convert.

Then put this in the first cell in that column:
=proper(a1)
(adjust the range to point at the first cell that needs to be converted)

Then drag that down as far as you need.

Then if you want to keep the helper column, you can convert it to values by:
selecting it.
Edit|copy
then select the original column and
Edit|paste special|values

Then delete that helper column.

This will convert any formulas to values (in that column), so be a little
careful.

 

[Guest]

I added a column B, then in B1 I entered (using the formula button) =PROPER and then O
It brought me to another screen wanting to knwo which cell I wanted so I clicked onn A
then went back to the formula screen

Now it does show me that it is doing what I wanted it do do in the little window. So I clicked O

The cell B1 has in it =PROPER(A1) but nothing happened

Should the words from A1 now appeer in B1?

 

[Dave Peterson]

Yes, it should.

What appears in A1?

What appears in B1?