From : Blog Entry >> Brian’s Blog Entry
***Please enjoy this blog posted on behalf of the author Kathy Dallaire, CEDS, eDiscovery and Litigation Support Coordinator, Stikeman Elliot LLP. In this blog, we will demonstrate some handy Excel formulas commonly used to build load files where the information required is spread out over multiple spreadsheets or has been parsed out into separate cells. While there can be numerous situations which require manually building a load file, hopefully these tips will save you some time and effort. [More]