Skip to content
Archive of entries posted on July 2008

How to parse non-delimited text data using Excel macro

Continuing the Excel macro theme… many employees receive company data from mainframe systems–perhaps even a screen copy or web paste.
Often the data is not delimited or structured in any way, so it does not want to go into Excel columns.  They must first spend significant time ’shaping the data’ into columns and rows prior to [...]