The data appears as:

Name StreetAddress (return) City State
PO Box


The second column has the street address and the PO box in one cell
separated by a hard return (Alt+Enter). I tried Text-to-Columns but I have
3000 rows of data.


"akphidelt" wrote:

Can you show an example of how the data looks? Is it separated by a space, -,
or what?

In the mean time mess around with Data---Text-to-Columns

You can separate by spaces, commas, or whatever you want


"DeeW" wrote:

I am using Excel 2003. I have a list of addressees that may have been
exported from Outlook. In the address field, there is a return that
separates the street address from the suite number. I need to place this
data into separate cells. How would I do this?