Tag Archives: Import large files

Daily Download 32: Text functions

Today’s daily download covers functions to import data from text files into Excel quickly and efficiently, a function to combine text strings, with improved functionality over the built-in Concatenate function, and functions to extract numbers from the beginning or end … Continue reading

Posted in Excel, UDFs, VBA | Tagged , , , , , , | 1 Comment

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