Tag Archives: split text

Importing text files with VBA – 3

The text import file has been modified to split large files into one or more ranges. The maximum number of rows for each range is specified, together with a sufficient number of valid range names, which may be on the … Continue reading

Posted in Excel, UDFs | Tagged , , , , , | 20 Comments

Importing text files with VBA – 2

Previous post The text file import routines and functions presented in the previous post have been modified with the following additions: Lines of text can be split into separate cells, at any designated character (e.g. a coma or a space) … Continue reading

Posted in Excel, UDFs | Tagged , , , , | 6 Comments