Printing a quotation mark (") in concatenate formula?

Hi, I'm trying to write a function using =CONCATENATE() and I want to know how to add a quotation mark to the output without it screwing up the forumula.


This doesn't print out the quotation mark " between B2 and B3:


=CONCATENATE(B2,""",B3)


I've been able to do it by referencing another absolute cell with a quotation mark in it, but that's definitely the wonky way to do it.


I think what I'm looking for is an escape character. In Excel, it's four consecutive quotes that prints a single quotation mark """"


(I'm using the function to generate html, which uses a lot of quotation marks)


Any help appreciated, thanks!

Numbers-OTHER, Mac OS X (10.7)

Posted on Aug 15, 2011 7:01 AM

Reply
1 reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Printing a quotation mark (") in concatenate formula?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.