How to Enter a Subscript in Excel. Properly formatting expressions such as "H2O" in your Excel spreadsheet requires the use of subscripts. Subscript formatting makes a letter or number appear ...

How to Separate Text From Numbers in Excel. When you open a raw data file in Excel, the program doesn't always recognize the way in which the data is formatted, such as comma-delimited, tab ...

Ultimately, Excel expects you to enter text, numbers, formulas, or mathematical symbols only into its cells, so you should avoid inserting anything else—including currency symbols.

In Excel, when these values are text — part numbers, ZIP codes, and so on — you don’t have a problem. Simply precede the value with an apostrophe character (‘).

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.