Formulas and Functions
ਇਸ ਕੰਟਰੋਲ ਦੀ ਸੋਧ ਕਰਨ ਨਾਲ ਇਹ ਪੰਨਾ ਆਪਣੇ ਆਪ ਅੱਪਡੇਟ ਹੋ ਜਾਵੇਗਾ

Tips for using double quotations in formulas

You can use double quotations in a formula to indicate a string. You can also escape the double quotations, which causes Numbers, Pages and Keynote to return quotation marks as part of a text string, instead of treating it as the start or end of a string.

In the example below, the quotation marks indicate the start and end of the string, with no quotation marks included in the result.

Formula

Result

="My favourite drink is Ginger Beer"

My favourite drink is Ginger Beer

If you want to include quotation marks in the result, you can add additional double quotations as escape characters.

In the example below, the first and last quotations indicate the start and end of the string. The two pairs of double quotations indicate that a double quotation should be returned as text on each side of the term "Ginger Beer".

Formula

Result

="My favourite drink is ""Ginger Beer"""

My favourite drink is "Ginger Beer"

Double quotations can also be used in the same formula as cell references to indicate a string.

For the example below, let A1 contain "My favourite drink is".

Formula

Result

=A1 & "Lemonade"

My favourite drink is Lemonade

In the example below, additional double quotation marks are used as escape characters around the reference to cell A1 (A1 contains "Green Tea") to return quotation marks in the result.

Formula

Result

="My favourite drink is """&A1&""""

My favourite drink is "Earl Grey Tea"

You can also use CHAR with code-number 34 to indicate where you want to return a double quotation.

See alsoFormulas overviewAdd and edit formulasReview formula errors and follow best practicesCopy or move formulas and their computed valuesRefer to cells in formulasFunctions overview
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
ਕੋਈ ਮਦਦ ਮਿਲੀ?
ਅੱਖਰ ਸੀਮਾ: 250
ਵੱਧ ਤੋਂ ਵੱਧ ਅੱਖਰ ਸੀਮਾ 250 ਹੈ
ਫ਼ੀਡਬੈਕ ਲਈ ਤੁਹਾਡਾ ਧੰਨਵਾਦ।
Morty Proxy This is a proxified and sanitized view of the page, visit original site.