Category "excel-2013"

Camel case converter in an excel

I am trying to convert a field in an excel sheet (e.g. REC_LEN) to camel case. I am using this formula to do that =LEFT(A1) & RIGHT(SUBSTITUTE(PROPER(A1),