numbers and text
The Replace function replaces part of a text string, based on the number of characters you specify, with a different text string. The Substitute function substitutes newtext for old text in a text string. You use Substitute when you want to replace specific text in a text string and you use Replace when you want to replace any text that occurs in a specific location in a text string.
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.
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.