O/T Excel Help
 

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.

Thanks

Keith (Southend)

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

O/T Excel Help
 

"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

O/T Excel Help
 

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

O/T Excel Help
 

Ouch ~ Excel crashed :-(

On Sat, 19 Feb 2005 18:20:09 +0000, "Keith (Southend)"
wrote:

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.

Keith (Southend)

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


Keith (Southend)

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

O/T Excel Help
 

"Keith (Southend)" wrote in message
...
Wow, that was a quick reply.

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


Luckily I just happened to be passing! :-)

If I remember correctly you put the cell reference not the words.
=PROPER(C11) for example I think.

Victor

O/T Excel Help
 

In article ,
"Keith (Southend)" writes:
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.

You want to use the last of these options. So if the text is in A1, say,
then in cell B1 (or whatever the next unused cell in the row is) you
might put =proper(A1). Then if your list items are in column A (A1, A2
etc) then you can just drag your formula in B1 down column B and it will
automatically adjust so that in B2 you get =proper(A2) and so on. (It
will work just as well with rows as with columns, if that is how your
list of text items is laid out.)
--
John Hall
"The power of accurate observation is commonly called cynicism
by those who have not got it."
George Bernard Shaw

O/T Excel Help
 

Excellent, that did the job John.

Many thanks for all the replies and help.

Keith (Southend)

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

On Sat, 19 Feb 2005 18:30:40 +0000, John Hall
wrote:

You want to use the last of these options. So if the text is in A1, say,
then in cell B1 (or whatever the next unused cell in the row is) you
might put =proper(A1). Then if your list items are in column A (A1, A2
etc) then you can just drag your formula in B1 down column B and it will
automatically adjust so that in B2 you get =proper(A2) and so on. (It
will work just as well with rows as with columns, if that is how your
list of text items is laid out.)

O/T Excel Help
 

Keith (Southend) wrote:

You want to use the last of these options. So if the text is in A1, say,
then in cell B1 (or whatever the next unused cell in the row is) you
might put =proper(A1). Then if your list items are in column A (A1, A2
etc) then you can just drag your formula in B1 down column B and it will
automatically adjust so that in B2 you get =proper(A2) and so on. (It
will work just as well with rows as with columns, if that is how your
list of text items is laid out.)



If you then highlight column B and do a 'paste special, values' you can
delete column A without losing the contents of column B.

A bonus tip as you seem to deserve it! (though probably didn't need it.)

--
Gianna Stefani

www.buchan-meteo.org.uk

O/T Excel Help
 

Gianna Stefani wrote:
Keith (Southend) wrote:


You want to use the last of these options. So if the text is in A1, say,
then in cell B1 (or whatever the next unused cell in the row is) you
might put =proper(A1). Then if your list items are in column A (A1, A2
etc) then you can just drag your formula in B1 down column B and it will
automatically adjust so that in B2 you get =proper(A2) and so on. (It
will work just as well with rows as with columns, if that is how your
list of text items is laid out.)




If you then highlight column B and do a 'paste special, values' you can
delete column A without losing the contents of column B.

A bonus tip as you seem to deserve it! (though probably didn't need it.)


ooops
'hightlight, copy, paste special-values'

brain faster than typing ... sorry

--
Gianna Stefani

www.buchan-meteo.org.uk

O/T Excel Help
 

In uk.sci.weather on Sat, 19 Feb 2005 at 18:43:08, Keith (Southend)
wrote :

Excellent, that did the job John.

Many thanks for all the replies and help.

Same from me - I can't believe how many years I've been using Excel
without knowing about this function!

This is what happens when they stop producing printed manuals. :(
--
Paul Hyett, Cheltenham