How-To Geek on MSN

How to use the PivotTable Fields pane in Microsoft Excel

You can create a PivotTable in Excel from an external data source, a table in your worksheet, or a pre-built data model. To ...
JournalofAccountancy

Using TEXTSPLIT to dissect Excel text strings

I have used the Excel functions LEFT, MID, and RIGHT to dissect cells. However, I have some spreadsheets where each piece of information is a different length and uses different delimiters. Is there ...