There is no reason why you cannot type that in. As there are letters in it, it will be treated by Excel as text.
Yes. It is text because it has spaces and letters in it, so it cannot be a number or a date or any other data type Excel has.
true
true
The single quote, like this: '2/11/14
text
Select cell formatting and change to text. After than, Excel will treat the numbers in a cell the same as any other text characters. Also, you will not be able to use that cell in a formula, because the formula will not recognize the characters as numbers.
By default, text in Excel is left aligned.
No. You use the & as the concatenation character in a formula. The following will add the two pieces of text together resulting in one piece of text: ="Hello " & "World"
Excel does not create stylized text, but you can insert WordArt. You will find the WordArt option in Excel 2007 on the Insert tab in the Text section.
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.
A DOS editor is not capable of reading a standard Excel file. An Excel file must be opened with Excel or some application that can read Excel files. Text editors are not capable of doing that. They are designed for working on things like text files.If you have a standard Excel file and save it as a text file, then text editors can open them. All that will be in that is pure text, and not things like formulas and calculations and formatting etc. When you are saving as a text file, save it with a txt extension and most text editors will be able to open it. How you specifically do it will depend on the particular text editor you are using.
You use the LEN function. Say you had some text in cell A2 and you wanted to find out how long it was, then you would type the following formula: =LEN(A2)
text in a cell