• Login
  • Courses
  • Books
  • Cheat Sheets
  • Tutorials Archive
  • VBA Code Generator
  • Contact

Power Spreadsheets

Excel and VBA tutorials and training. Learn how to use Microsoft Excel and Visual Basic for Applications now.

Excel Concatenate Double Quote: Formula Example

This Excel concatenate double quote formula example helps you:

  • Insert double quotes (“);
  • When joining strings.
Excel concatenate double quote example formula

Table of Contents

  • Excel Concatenate Double Quote Formula Template
  • Excel Concatenate Double Quote Example Formula
  • Excel Concatenate Double Quote Explanation
  • More Excel Concatenate Formula Examples
  • More Excel Training Materials and Resources

Excel Concatenate Double Quote Formula Template

'Source: https://powerspreadsheets.com/
'More information: https://powerspreadsheets.com/excel-concatenate-double-quote/

'String DoubleQuote String DoubleQuote
=String1&CHAR(34)&String2&CHAR(34)

For these purposes:

  • String1 and String2 are the strings you concatenate; and
  • String2 is wrapped in double quotes (“String2”).

Excel Concatenate Double Quote Example Formula

The Excel concatenate double quote example formula below:

  • Joins the strings stored in cells B6 and B7;
  • While wrapping the string stored in cell B7 in double quotes.
'Source: https://powerspreadsheets.com/
'More information: https://powerspreadsheets.com/excel-concatenate-double-quote/

=B6&CHAR(34)&B7&CHAR(34)

The image at the top of this post shows the results I obtain with this Excel concatenate double quote example formula.

Excel Concatenate Double Quote Explanation

The CHAR function returns a character specified by a code number. Code 34 (CHAR(34)) returns double quotes.

Therefore, use the CHAR function and code 34 (CHAR(34)) to insert double quotes when:

  • Concatenating text; and
  • Creating an Excel concatenate double quote formula.

You can (theoretically) use an additional set of double quotes as escape characters when creating an Excel concatenate double quote formula. The following 2 Excel concatenate double quote example formulas are equivalent.

'Source: https://powerspreadsheets.com/
'More information: https://powerspreadsheets.com/excel-concatenate-double-quote/

'Concatenate double quote with CHAR(34)
=B6&CHAR(34)&B7&CHAR(34)

'Concatenate double quote with " as escape character
=B6&""""&B7&""""

In my opinion, using double quotes as escape characters when creating an Excel concatenate double quote formula results in formulas that are more difficult to:

  • Read;
  • Follow;
  • Understand; and
  • Work with.

Consider the Excel concatenate double quote with ” as escape character example formula above. This formula requires 4 double quotes (“”””) to return a single double quote (“) in the formula output. These 4 double quotes do the following:

  • The outer double quotes (first and fourth) identify the string literal.
  • The second double quote acts as an escape character.
  • The third double quote is the double quote displayed in the formula output.

The ampersand text concatenation operator (&):

  • Concatenates strings; and
  • Returns a single string with the concatenated items.

The ampersand text concatenation operator (&) is not the only way to concatenate items. You can find more Excel concatenate formula examples in the More Excel Concatenate Formula Examples section.

More Excel Concatenate Formula Examples

This formula example is part of a more comprehensive series of Excel concatenate formula examples.

  • Excel Concatenate Strings: Click here to open.
  • Excel Concatenate Number and String: Click here to open.
  • Excel Concatenate Date: Click here to open.
  • Excel Concatenate with Space: Click here to open.
  • Excel Concatenate New Line: Click here to open.
  • Excel Concatenate Double Quote: Click here to open.
  • Excel Concatenate Multiple Cells with Comma: Click here to open.

More Excel Training Materials and Resources

You can find more Excel Tutorials (including other formula examples) in the organized Tutorials Archive: Click here to visit the Archives.

If you want to ease all your operations and processes, you may be interested in Someka's ready-to-use Excel and Google Sheets templates. Someka's template collections cover, among others:

  • Project Management;
  • Human Resources;
  • Sales and Marketing;
  • Inventory Management;
  • Calendars and Timesheets;
  • Budgets; and
  • Invoices.

Click here to learn more about Someka's Excel and Google Sheets templates

guest
guest
1 Comment
Most Voted
Newest Oldest
Inline Feedbacks
View all comments

I publish a lot of Tutorials and Training Resources about Microsoft Excel and VBA. Here are some of my most popular Excel Training Resources:

  1. Free Excel VBA Email Course
  2. Excel Macro Tutorial for Beginners
  3. Excel Power Query (Get and Transform) Tutorial for Beginners
  4. Excel Keyboard Shortcut Cheat Sheet
  5. Excel Resources
Terms and Conditions

Privacy Policy

Limit of Liability and Disclaimer of Warranty

Affiliate Disclosure

Copyright © 2015–2023 PDS Intelligence Pte. Ltd. All rights reserved.
Excel ® is a registered trademark of the Microsoft Corporation. Power Spreadsheets is not affiliated with the Microsoft Corporation.