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
tencat951- take a look at HansVogelaar response
HansVogelaar wrote: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.
ChrisMendoza Hi there. I have copied a Concat formula into a weekly spreadsheet for over a year and it worked like charm. Someone else created it, I'm not expert. But all of a sudden it won't calculate any more. It is formatted as "General' and "Show Formulas" under the Formulas menu is off. I have tried to copy the formula into a different brand new Excel file and it still doesn't work. Help!
=CONCATENATE("[",LEFT(D2,1),LEFT(MID(D2,(FIND(" ",D2,1))+1,256),1),"-",C2,"]"," ",F2)
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.
