I installed "Power Query" in Excel 2013. Works fine. However it doesn't support VBA. No code is generated when I try to make a macro with the macro recorder. Wh
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),