Wow, that was a quick reply.

Not sure what to put in the 'text' quotes as every word in the list is
different?

Thanks Keith (Southend)

Syntax

PROPER(text)

Text is text enclosed in quotation marks, a formula that returns
text, or a reference to a cell containing the text you want to
partially capitalize.

Examples

PROPER("this is a TITLE") equals "This Is A Title"

PROPER("2-cent's worth") equals "2-Cent'S Worth"

PROPER("76BudGet") equals "76Budget"

Wow, that was a quick reply.

On Sat, 19 Feb 2005 18:12:12 -0000, "Victor West"
wrote:


"Keith (Southend)" wrote in message
.. .
Is there a quick way I can convert a long list of text from UPPER Case
to LOWER Case, better still, LOWER Case apart from the first letter in
each word?

The HELP comes up with the 'PROPER' function, but this doesn't seem a
quick method to me.


I've used the PROPER function at work at it's quick enough for me. I can't
remember the formula exactly but if you copy and paste it down the list it
should be done in no time.

Victor



Keith (Southend)

***********************
Weather Home & Abroad
http://www.southendweather.net