If the text that you want to convert is in A1
enter this in any cell you fancy.
=PROPER(A1)

I'll leave the rest to you.

George Gee



"andy_" wrote in
message ...

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