0
It indicates text. You usually use a pair of quotes to symbolise text, often within formulas. If you don't have something to indicate text, then Excel will think it refers to a particular thing in a spreadsheet, which it then cannot find. If you want to find the length of a piece of text, you can use the LEN function. If you type the text into a cell, you can refer to that cell directly. If you had some text in cell A3, then the following formula will tell you how long the text is:
=LEN(A3)
In this case Excel knows that A3 refers to a cell. If you do the following formula you will get an error:
=LEN(John)
This is because it does not know what John is. It is not a cell like A3 is and it does not refer to anything else. If you want to find the length of the word John, then you would have to do it like this:
=LEN("John")
Now Excel knows you are referring to a piece of text, so it will give the answer 4.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What symbol is in excel?
There is no symbol for "actual" in Excel, but there is a function to display absolute value (ABS).
What is Actual symbol in Excel?
There is no symbol for "actual" in Excel, but there is a function to display absolute value (ABS).
When would you use the - symbol in excel?
We use symbols in excel when we need to add a symbol of copyright, trademark symbols, and Unicode symbols etc.
What the symbol for format in excel?
it is a picture with a paintbrush.
Which symbol represents an Excel numeric field that is too wide to display?
The # symbol.
Is C a symbol for a mathematical operation in Excel?
No it isn't.
How can you draw the squared symbol in excel?
See the Ribbon
What is the excel formula symbol for any number?
1()
What is 12.5 percent in Excel?
12.5 percent can be written with a percent symbol or as a decimal in Excel: 12.5% 0.125
How do you add less than symbol in Excel?
The less than symbol is and you can add the symbol in the input line when typing a formula.
What is the symbol that tells excel that you are about to begin a formula?
the asterisk is used for what function when building a formula in excel
How do you make a flatness symbol in excel?
ChatGPT In Excel, creating a flatness symbol (⌀) involves using the "Insert Symbol" feature. Click on the cell where you want the symbol, go to the "Insert" tab, choose "Symbol," and a window will appear. Select "Arial" as the font, locate the flatness symbol (⌀), and click "Insert." Alternatively, you can use the Unicode character by typing "=UNICHAR(8960)" in a cell and pressing Enter. This method allows you to incorporate symbols, like the flatness symbol, into your Excel worksheets.
