G
Guest
For a line that has been copied into Excel with two end of line characters, what is the code in VB for excel to parse the line and enter it into 2 columns. This is an address with the street numberand name of the street then there are the end of line characters (2 boxes) and then the city and state. I need the street address in one column and the city and state in the another column.