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...
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
As mentioned in other replies in this discussion:
- Make sure that the cell with the formula is not formatted as Text.
- Make sure that the Show Formulas button in the Formula Auditing group of the Formulas tab of the ribbon is not highlighted.