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 of text strings.
The text import spreadsheet is described in the following posts:
Importing text files with VBA
Importing text files with VBA – 2
Importing text files with VBA – 3
Importing tab delimited files and clearing large ranges
Importing selected rows from a text file
Download file: http://www.interactiveds.com.au/software/Text-in2.ZIP
A separate spreadsheet allows automatic download of csv files from the web:
Automatic download of csv files
Download file: http://www.interactiveds.com.au/software/web-download1.xlsb
The Textstring Function is described in:
Stringing more than two words together
Download file: http://interactiveds.com.au/software/TextString.xls
The functions NumLeft and NumRight will extract numbers from the start or end of a text string, and are described in:
Extracting Numbers From Text Strings
Download file: GetNum.xlsb
1.4 million row text file imported into Excel 2007
Text import with criteria ranges
CSV data imported from the Internet
TextString Function examples compared with Concatenate
Newton Excel Bach, not (just) an Excel Blog 