Using Text and Data Functions

image with no caption

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.

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

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.