the code assigns the cell’s value tomyStr, then it usesthe Proper functionfrom the ExcelWorksheetFunctionobject to capitalize the first letter of each word inmyStr. The result is assigned to thelettervariable and then appended to the corresponding cell inoutputRng. ...
Excel has lots of useful functions suitable for capitalizing first letter in the cells. However, you can't have both, your data and formula that references it, in one cell. Thus, you need to create a helper column somewhere in your worksheet in order to place the formulas there. When it...