O'Reilly logo

Excel 2010 Financials Cookbook by Andre Odnoha

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

Splitting financial data

Financial data is compiled in numerous methods and from numerous sources. As discussed earlier, those sources do not always share the same methodology in how to format data. Also, when exporting data from many databases, the data is often forced together in long text strings. In most cases data that requires separation will contain some character or characteristic that will serve as the separation point.

This recipe will explain how to use identified separation points to split data into useable pieces.

Getting ready

As mentioned earlier within the recipe Setting up an Excel spreadsheet, the more granular the data you are working with, the more useful it will be. Long lines of text combining salesperson names and sales figures ...

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