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)