Using Quotes (") in Text Formula

[Fujirich]

I need to use a quote symbol ( " ) to indicate inch measurements in a text portion of a formula. I'm not sure how, or if this can be done. Here's an example of a formula, with the * representing where I'd want the quote (or inch) symbol to appear:

=A19&", "&A20&"* x "&A21&"*"

Since quotes are used to begin and end text portions of the formula, how can I actually insert a quote that will become text once the results are displayed?

Thanks for any ideas

Rich

 

[Brian from Maui]

I need to use a quote symbol ( " ) to indicate inch measurements in a text portion of a formula. I'm not sure how, or if this can be done. Here's an example of a formula, with the * representing where I'd want the quote (or inch) symbol to appear:

=A19&", "&A20&"* x "&A21&"*"

Since quotes are used to begin and end text portions of the formula, how can I actually insert a quote that will become text once the results are displayed?

Thanks for any ideas

Rich

Try,

=A19&""", "&A20&""" x "&A21&""""

 

[Aladin Akyurek]

=A19&", "&A20&CHAR(34)&" x "&A21&CHAR(34)

 

[Fujirich]

Brain & Aladin - thanks to both of you; each of your suggestions worked great!

Thanks so much for the help!