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 ...

You can remove leading, trailing, and extra spaces between characters and numbers in Excel using TRIM(), SUBSTITUTE() or Find and Replace.

You can save time by creating an AutoFill series in Excel 2003 as follows: Enter the values and then select the list. Choose Options from the Tools menu. Click the Custom Lists tab. Click Import.