I have a formula in cell A1 that outputs a single letter in cell A2. So, for example, if I apply the formula three times I might get X, followed by H, followed by A.
I want to somehow join (I think the term is “concatenate”) the results of these three calculations to give XHA in cell A3.
Is there any way of doing this using Excel’s built-in functions, or do I need code?
EDIT
My mistake. Assume the formula in A2 is =CHAR(65+A1). 23 gives X, 7 gives H, 1 gives A. After three calculations I want XHA to appear in cell A3. How can I do that?
