These characters include letters, numbers, and special characters such as spaces, the dash symbol ( - ), or the number sign ( # ).
Usually text strings begin with a letter of the alphabet, but in many spreadsheet programs any data entry that has been formatted as text is interpreted as a string.
A text sting can also be created by entering an apostrophe ( ' ) as the first character of data.
The apostrophe is not visible in the cell but forces the program to interpret whatever numbers or symbols are entered after the apostrophe as text.
For example, to enter a formula such as = A1 + B2 as a text string, type
' = A1 + B2
The apostrophe, while not visible, prevents the spreadsheet program from interpreting the entry as a formula.
By default, text strings are left aligned in a cell.