Hi Diane,
(Reusing reply just used in another thread)

You need a macro to do what you want. A function can only return
a value, so if you don't want the little dance routine to convert formulas
to values and remove the original column, you would need to use a
macro.

With a macro all you need to do is select the cells to be converted.
If the macro is properly written it will restrict itself to the used range
(one way is with SpecialCells), then you can select entire columns
or the entire worksheet. If it is not properly written converting a
single column could take 3 minutes (65536 cells on 600mHz with 128MB RAM).
You should hardly notice converting 4000 cells in a column.

Proper, and other Text changes -- Use of SpecialCells
http://www.mvps.org/dmcritchie/excel/proper.htm#proper
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Diane Walker" wrote ...
I got [have] this file that has employee names. However, the names are all in
capital letters. Is there a way to break the name in the appropriate case?
For example, the name is JOE SMITH. I would like the name to be displayed
as Joe Smith. Thanks.