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...
Not sure what you're experiencing on your side but this is what I get:
You don't need the commas when using & to join.
I have typed in the formula just as shown - I tried this using ampersand and the concat function. And the result is not the function but the formula I typed in.
I successfully completed this task on another work sheet in the same document. Only difference is I was combining two text cells and not three.
Very frustrating.
Help