Parsing

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Don't know if you really need VBA for this but if you do
record a macro while doing data>text to columns, delimited, click next,
select other, click in the other box and hold down alt while typing 010 on
the numpad,
click next, select the empty column in step 3 and select [do not import] and
click finish




--

Regards,

Peo Sjoblom

Sarah said:
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.
 
Back
Top