Select the column and EditReplace

What: CTRL + j

With: space

Replace all.

Now do the T to C as space-delimited on second column.

Make sure you have a blank column to the right of second column


Gord Dibben MS Excel MVP

On Wed, 2 Apr 2008 11:56:01 -0700, DeeW wrote:

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?