Assuming your list is in column A. in B1, type =PROPER(A1) and copy down.
then you can paste special values.

Thanks
Gaurav

"Lightjag" wrote in message
...
I am referencing a text string in excel, and would like to return the text
string with the first letter capitalized. How can I do this?