Excel: Split A Column Into Multiple Columns

[Brett_Johnson]

Address.txt (20 Bytes)

It looks like the prior method was adding “” around the address.

Using “Write Cell” with Split(strAddyTempString,”,”)(0).ToString.Trim solved it. No more extra line.

Based on your trim idea earlier as well as the the following post:

Extract part of string before the comma "," and put in a variable. Then extract string after dash "-" and put in variable

I need to extract two parts of a string and put them in a variable. For example, my format is “lastname,firstname-1234”. I need to extract the last name and put it in a variable and then extract 1234 and put it in a variable.