Do you mean
=PROPER(A1)
doesn't work?
What do you have in A1 and what result do you get?

"LaDena" wrote in message
...
I have used the formula before, but with this spreadsheet I had to use the
"data to text" function to split the whole name to first and last name
columns. Now the proper case formula will not work.

Any suggestions would be appreciated.

Thanks,
Dena