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...
Jesse_ou812
Jul 08, 2024Copper Contributor
I too have this problem and tried all suggested solutions. It appears there is a bug or virus that is forcing the cell that the "concat" formula is being put in to become a text only cell and the formula does not get executed. I think I will again try to shut off the computer altogether and reboot - sometimes that works.