Excel 2010's CONCATENATE function allows you to combine several text strings into one single string within a cell. The text strings can either be spelled out in the CONCATENATE function or from cell references that point to cells that contain text. When using the function, double quotation marks within the formula designate text that needs to be added, but when you want the function to return a result that actually contains a double quote mark, things get a little complicated. Just putting a double quote mark in between two other double quote marks, as you would to display any other character, doesn't work. There are two ways to get around this problem.
Step 1
Click on the cell where you want the result of your CONCATENATE formula to appear.
Video of the Day
Step 2
Enter "=CONCATENATE(" to begin using the function.
Step 3
Enter the first text string that you want to include in the concatenation. Enter a cell reference without quotes, or an actual text string within double quotes. Place a comma after the entry, then enter the second text string.
Step 4
To enter a double quote mark use either four consecutive double quotes in between commas, or the string "char(34)" (not including the quotes). If your double quotes are going to surround a text string, and not a cell reference, you can also just put three double quote marks around the text string. For example, a CONCATENATE function for combining the text in cell A3 with a space and then the word "test" surrounded in double quotes could be written as follows:
=CONCATENATE(A3," ",char(34),"test",char(34)) =CONCATENATE(A3," ","""","test","""") =CONCATENATE(A3," ","""test""")
Video of the Day