Hi

This may works, try assuming cell A1 hold E.MAIN ST
place this formula in cell B1, PROPER(A1) and copy down to the last data
where column A is fill.
then select and copy the range in colmun B and do a paste special value
into the range in column A
--
Hope this help

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis





"sos-DC" wrote:

I have a huge database in excel.

Unfortunately, some of the entries are in ALL CAPS (E. MAIN ST or JOHN SMITH)

It is unfortunate as they need to be E. Main St or John Smith.

Is there any way to fix this without retyping every entry?