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...
sumk2k4
Mar 03, 2025Copper Contributor
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