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
Pingback: Dealing with dates 3: opening and saving csv files without data corruption | Newton Excel Bach, not (just) an Excel Blog