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?
Try,
=A19&""", "&A20&""" x "&A21&""""
and also this:
=A19&", "&A20&CHAR(34)&" x "&A21&CHAR(34)
No comments:
Post a Comment