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 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

This entry was posted in Excel, UDFs, VBA and tagged , , , , , , . Bookmark the permalink.

1 Response to Daily Download 32: Text functions

  1. Pingback: Dealing with dates 3: opening and saving csv files without data corruption | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.