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 THANK YOU. This is exactly the problem I was having and I can't believe it took more than an hour to finally have someone mention this may be the issue. You sir, are a savior.