![]() The result: The 1960's movie "The Graduate" is famous If you want to add the movie to other text to create, you can concatenate the movie title inside double quotes with a formula like this: ="The 1960's movie """ &A1&""" is famous" The outer quotes (1 & 4) tell Excel this is text, the 2nd quote tells Excel to escape the next character, and the 3rd quote is displayed. ![]() You'll also need to include double quotes wherever you would normally in a formula.įor example, if cell A1 contains the text: The Graduate and you want wrap that text inside double quotes (""), you can use this formula: =""""&A1&""""īecause the text on either side of A1 consists of only of a double quote, you need """". By escaping a character, you are telling Excel to treat the " character as literal text. ![]() ![]() To include double quotes inside a formula, you can use additional double quotes as escape characters. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |