David H. Ringstrom, CPA, heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at email@example.com or follow him on Twitter. David speaks at conferences about Microsoft Excel and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link.
Microsoft Excel Text Extraction Techniques
by David Ringstrom,CPA
Reports exported to Excel from QuickBooks often contain data aggregated into a single column that you may want to pare down. I’ve seen any number of folks over the years resort to manually retyping the data they want into a new column. In my experience retyping data is typically only required in special circumstances, as in most cases you can easily transform the data as needed. In this article I’ll share several Microsoft Excel text extraction techniques, including the rarely used InStrRev function.
Continue reading on www.sleeter.com.
About the author: