Use the PROPER function to convert text to first letter uppercase text.

if your text is in column a, insert a column to the right and in B1 enter
the formula
=PROPER(A1). Enter the formula and copy it down the column to convert all
of your uppercase text values in column A.

Copy all the data in column B, select cell A1 and click EDIT in the menu,
click PASTE SPECIAL and click the VALUES option button. Delete the formula
column and you're back in business.

The companion case convert functions are UPPER() and LOWER(), should you
have a need to ever do that kind of conversion.
--
Kevin Backmann


"andy_" wrote:


Hi everyone,

Got a small problem with excel.
I need to convert some text from upper case to lower case, easy i hear
you say..
The only problem is that the first letter of each word needs to be
upper case.
i.e TURBO DIESEL needs to be Turbo Diesel, this is just an example
there are too many variations to do a simple find and relplace
Any help would be appreciated

Thanks
Andy


--
andy_
------------------------------------------------------------------------
andy_'s Profile: http://www.excelforum.com/member.php...o&userid=32218
View this thread: http://www.excelforum.com/showthread...hreadid=519697