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