After making sure that the target cell is formatted as General, re-enter
the formula. Does this help?

In article ,
Pingu_3D wrote:

When I use the Concatonate wizard it shows the expected result in the wizard
dialogue box but when I press OK it just shows the formula in the cell rather
than the result.
I have tried formatting the target cell as General and Text and saved,
closed and reopened the file but it doesn't help.
I have the same problem with Substitute.

What's going on?