This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Need help with CONCAT function. I am simply trying to combine text cells into a comma separated string. I typed =CONCAT(C9,D9,E9,H9) and ENTER. Nothing happens. If i hover over the formula, it shows me the text from the cell, but when I hit enter, it doesnt have it typed out as a result. How do i see the rendered result in the chain I thought I was building?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Just add a space after the comma (the comma within the double quotes) in the formula:
=TEXTJOIN(", ",TRUE,C9,D9,E9,H9)
Answer accepted by question author
Try this instead:
=TEXTJOIN(",",TRUE,C9,D9,E9,H9)
YOU ARE A SUPERHERO!!! THANK YOU!!!!!!!!!!!!!!!!!
this worked so much easier! BUT how do i put a space after the comma in the chain? use the " " ?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 92%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
B. Deitrick's suggestion of using TEXTJOIN is better for what you are wanting to do. It is available in Excel 2019 and later. In case that is not available, to create a comma separated string with CONCAT use this modification.
=CONCAT(C9,",",D9,",",E9,",",F9)
However, you said that when you pressed Enter nothing happens. What do you mean? Is the cell blank or do you just still see the formula?
If the cell is blank but the formula is in the Formula Bar, check the text color in the cell to make sure it contrasts with the cell color.
If you still see the formula, the cell is likely formatted as text. Click in the cell, in the center of the Home ribbon use the format dropdown to change the formatting to General, press the F2 key, and then press Enter. That will reformat the cell and re-enter the formula so it will calculate.