O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required