If you are asking, how do I put a second line in the same cell the answer is: Type the first line of text, the hold down the Alt key and press Enter, i.e. "Alt + Enter". Your cell will now take two lines. You can do this as many times as required.
numbers and text
number instead of a letter (text)
A possible answer is text, numbers, and special characters.
Start your entry with an apostrophe (') to indicate the cell contents is text.
A column break is a term associated with Microsoft Word, not Excel. In Word, it starts a new column of text. In Excel, you can just go to another column to start entering new data.
Format the cell as text. You also can input a formula: =text(A1) Remark: if the content is in cell A1.
Because there are letters in it, it treats it as text. So it is not changing it from time to text, if that is what you mean. It is text, because of the letters that are in it.
A cell is a rectangle that can hold a number, text, formula etc.
The Find and Replace option can be used to replace text in Excel. A particular piece of text can be replaced throughout the document using Replace All. Use Ctrl - H to activate the Replace option in Excel.
text and numbers formatted in a variety of ways
The text functions are a set of functions in Excel that are used to manipulate text. They can be used for things like finding the length of a piece of text or extracting part of a piece of text from it or change it to upper or lower case. There are many other things that they can be used for.
No they are not interchangeable. There are things that both can do, but Microsoft Word is a word processor and Microsoft Excel is an electronic spreadsheet. So they are both designed for different kinds of jobs. You can copy things between one and the other, like if you have a report in Word, and wanted to include some figures from Excel. Microsoft Word is for working with text and Microsoft Excel is for doing large scale calculations and other numerical analysis and manipulation.