In the example, entering the combined values in K2 as a formula produces the result in J2. J2 is value copied and pasted in J4. To confirm that it is a formula that will not produce an error, the text of J4 is copied and entered as a formula in J6 (which does produce the proper result). It was believed the EVALUATE function would take care of all these steps so you could just combine the formula in K2 with EVALUATE, and it would produce the result in J6 (and H2). However, when that combination is tried in J8, it gives an error message. Is there something in the J8 formula (shown in K8) that is not being entered properly? Is there a way for excel to evaluate the formula in K2 and get the same result as J6?
)
in your formula string.