how do I convert text in excel to 1st letter capital,only
 

I seem to be unable to get the data function 'proper' to work on a
spreadsheet. I want to convert entries in cells so that the first letter is a
capital, and the rest are in lower case. Can anyone help, I have used the
help function on excel, but sem unable to get it to do what I require.

what is it that you require that is not being done by using the
=proper()function?

--
Don Guillett
SalesAid Software

"jmfp" wrote in message
...
I seem to be unable to get the data function 'proper' to work on a
spreadsheet. I want to convert entries in cells so that the first letter
is a
capital, and the rest are in lower case. Can anyone help, I have used the
help function on excel, but sem unable to get it to do what I require.