Forum Discussion
CONCAT Function Not Working
Hi, Using Office 365 here (installed on PC). Entering =CONCAT(G2," ",H2) to join the two text values in these cells and when clicking enter the formula appears in the cell, not a string of the t...
The problem is not with the referenced cells being formatted as text; it is likely that the formula cell was accidentally formatted as text which will block any formula you may enter into that cell from working.
PeterBartholomew1 I did check that when I was trying to troubleshoot and I believe it was set as General. So how should the formula cell be formatted?
General should be fine. There is a catch in that reinstating General in place of Text doesn't automatically sort the problem. The formula also has to be committed with Enter as if it were newly input.
