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...
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.
- If still not working just restart your computer after finishing the above two task. cheers