Forum Discussion
AdiAtNoname
Jan 15, 2020Copper Contributor
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...
Lauraleiwhit
Apr 05, 2020Copper Contributor
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?
PeterBartholomew1
Apr 05, 2020Silver Contributor
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.