Currently I have this:

= "Account ="&A2

Which looks like this:

Account = 123123123123

This is what I'm trying to do:

Account = '123123123123'

How Do I add the single quote, i.e., ' in between the &A2?*


2 Answers 2


When constructing a text string in Excel, cell references go by themselves and anything else goes inside double quotes. You connect the pieces (as you already know) using &.

So for your example, just include single quotes inside double quotes where you need them:

= "Account ='"&A2&"'"

  • Perfect, Thank you!
    – Steve
    Commented Mar 11, 2020 at 16:44

You need to concatenate the strings together like this:

=CONCAT( "Account ="," '",A2,"'")

Which provides the desired outcome

enter image description here

  • Feel free to mark the answer and/or upvote it. Commented Mar 11, 2020 at 17:12

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .