હિમાંશુ પરભુભાઇ મિસ્ત્રી | 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

ટિપ્પણી આપો »

હજુ સુધી કોઈ ટિપ્પણીઓ નથી.

RSS feed for comments on this post. TrackBack URI

પ્રતિસાદ આપો

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / બદલો )

Twitter picture

You are commenting using your Twitter account. Log Out / બદલો )

Facebook photo

You are commenting using your Facebook account. Log Out / બદલો )

Google+ photo

You are commenting using your Google+ account. Log Out / બદલો )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: