I recently posted a question seeking alternative solutions to "&" and was suggested that "concatenate" could work as an alternative.
It's all well and good UNTIL it is NOT.
Now my "concatenate" gives me "#VALUE!". If I use "concatenate(transpose()) + Fn F9, it ONLY gives me the content in the first cell.
Googling the problem suggests that I need to turn off Transition Formula Evaluation (TFE) or Alternate Expression Evaluation (AEE).
However, under file>options>advanced the TFE under Lotus compatibility is NOT on. I turned it on and off but still problem persists.

Any other solution ? Great many thanks.

version: Microsoft Office Professional Plus 2010