Tag Archives: String Processing

No Thumbnail

Excel VBA Chr() Function

In this article I will explain about the Chr() function. The Chr() function is a very useful function when working with strings and Excel columns. Generally speaking, numbers and characters are mapped. Meaning that each character is mapped to a number and vice versa. For

No Thumbnail

Excel VBA, Text File to Columns

In this article I will explain how you can read the values in a text file and print them in columns in Excel. For example lets say we have the following data in a text file: We want to read the data from the text