Open delimited text file and insert values as text

  • Just wrote this for someone else that had a delimited text file but Excel was parsing the values as numbers and dropping the leading "0"s


    This will open the text file and read it in using the supplied delimiter, and return a 2D array. You can then use that array to target the range that the data is going to be placed and set the formatting accordingly.


    Might save someone some time instead of having to go through and wrap everything in quotes.



    Example Use: