હિમાંશુ પરભુભાઇ મિસ્ત્રી | Himanshu Mistry

જાન્યુઆરી 13, 2010

How to embade double quote mark (“) in Excel formula

Filed under: Uncategorized — Himanshubhai Mistry @ 5:37 પી એમ(pm)

How do I tell excel to treat a quotation mark (“) in an excel formula as a quotation mark (“) ?

Excel reads quotation marks as signifying text inside, but my text field requires a quotation mark (“) to be included in it as well, so I need to somehow tell Excel that the ” is part of the text field within the two quotation mark(“)s

below Solution worked for me:
eg:

=CHAR(34)&”Test”&CHAR(34)

returns

“Test”

Enjoy !!!

Advertisements

Create a free website or blog at WordPress.com.