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?