I have a software database program that downloads to an
Excel file. As it overwrites the file everytime that it
downloads I have to create another file to hold a report
that I have that uses the data. One column for the data
entered contains the address. Unfortunately, the address
comes across with the street address and the city and
state in one cell. The street address and the city and
state location are separated with what I believe to be an
end of line character. (2 squares) I am trying to parse
this so that the street address is in one cell and the
city and state are in another cell. I am trying to
automate this report so that it can be updated once a
week. This means that I am using VB code in Excel. Also,
I am transfering this to more than one sheet in the
workbook and transfering data into anywhere from 2 to 100
rows. I will need to use a loop and an index variable for
the row and the sheet. I would like to know the code to
use. I have tried .parse and .TextToColumn but I am not
having very good luck. Perhaps one of these does work but
I do not have the correct syntax.

Never mind I figured it out.


-----Original Message-----
I have a software database program that downloads to an
Excel file. As it overwrites the file everytime that it
downloads I have to create another file to hold a report
that I have that uses the data. One column for the data
entered contains the address. Unfortunately, the address
comes across with the street address and the city and
state in one cell. The street address and the city and
state location are separated with what I believe to be an
end of line character. (2 squares) I am trying to parse
this so that the street address is in one cell and the
city and state are in another cell. I am trying to
automate this report so that it can be updated once a
week. This means that I am using VB code in Excel.
Also,
I am transfering this to more than one sheet in the
workbook and transfering data into anywhere from 2 to 100
rows. I will need to use a loop and an index variable
for
the row and the sheet. I would like to know the code to
use. I have tried .parse and .TextToColumn but I am not
having very good luck. Perhaps one of these does work
but
I do not have the correct syntax.
.

Sarah.

Why don't you get the information directly into Excel from the database ?
What database are you using ?

The 2 squares you talk about are quite possibly char10 and char13 (CR/LF).

Chris

"Sarah" wrote in message
...
I have a software database program that downloads to an
Excel file. As it overwrites the file everytime that it
downloads I have to create another file to hold a report
that I have that uses the data. One column for the data
entered contains the address. Unfortunately, the address
comes across with the street address and the city and
state in one cell. The street address and the city and
state location are separated with what I believe to be an
end of line character. (2 squares) I am trying to parse
this so that the street address is in one cell and the
city and state are in another cell. I am trying to
automate this report so that it can be updated once a
week. This means that I am using VB code in Excel. Also,
I am transfering this to more than one sheet in the
workbook and transfering data into anywhere from 2 to 100
rows. I will need to use a loop and an index variable for
the row and the sheet. I would like to know the code to
use. I have tried .parse and .TextToColumn but I am not
having very good luck. Perhaps one of these does work but
I do not have the correct syntax.