I have a cell in column B that has all CAPS. I would like to set this to Camel Case.

First letter Cap and remaining letter lower case. Second Word should have the first letter cap and remaining letters lower case. I am on Office 365.

This is what I use and notice the value for the column B does not get generated. 

I did format the the column B cells to general. The formula exists in column C.

In column B when I type the formula it does appear as formula. 

XICENTE CAYANS=proper(B10)

​I have a cell in column B that has all CAPS. I would like to set this to Camel Case.First letter Cap and remaining letter lower case. Second Word should have the first letter cap and remaining letters lower case. I am on Office 365. This is what I use and notice the value for the column B does not get generated. I did format the the column B cells to general. The formula exists in column C.In column B when I type the formula it does appear as formula.  XICENTE CAYANS=proper(B10)  Read More

​