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

January 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 !!!

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

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 / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: