Insert double quotes into a formula

This tutorial shows how to add double quotation marks into a formula using an Excel formula or VBA

Example: Insert double quotes into a formula

Insert double quotes into a formula

METHOD 1. Insert double quotes into a formula using Excel formula

EXCEL

="My "&""""&B5&""""&" sport is"
To insert the quotation marks in a formula whilst referencing to a cell we need to enclose the quotation marks in quotation marks.

Explanation about how to insert double quotes into a formula

EXPLANATION

EXPLANATION
This tutorial shows how to insert the quotation marks into a formula.
FORMULAS
="text"&""""&value&""""