Microsoft® Excel® 2010 Formulas & Functions Inside Out

Using Text and Data Functions

With the text and data functions of Excel, you can view your data in a variety of formats as well as convert data or perform calculations in combination with other functions. You will find further solutions in the following practical examples.

Sample Files

Use the worksheet found in the the Text_Data.xls or Text_Data.xlsx sample file. The sample files are found in the Chapter02 folder. For more information about the sample files, see the section titled Using the Sample Files.

Separating Text Strings Such as ZIP Code and Location

Assume that you have an address list in which one column contains a location consisting of the ...