Unfortunately I don't

The addresses are as follows:
330 6th Avenue North, Suite 200 Southport, MS 98227

All of that is in one cell...Any other suggestions?



"Kentle" wrote:

if you have commas or other separators in the cells than use the text to
columns function in the data menu - it is a wizard function that will guide
you though the steps

"corkypine" wrote:

I have about 2000 addresses that need to be separated.

In one cell the street address, city, state and zip are all locatated in one
cell. Is there a way that I can separate this so that the street address,
city, state, and zip all have a separate cell?