Excel 2003 - Split Content of Cell w/Text Separator (Return)

[DeeW]

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?

 

[akphidelt]

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]

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.

 

[Gord Dibben]

Select the column and Edit>Replace

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