Hello,
I need some help ASAP for any of you that can save me!

In Excel '07, I have a cell with all of a persons contact info.

Firstname MI Lastname Address Street State Zip

Problem is there is no uniform structure. No tabbing, identifiers, and
everything might not be included. For example:

Jane M Doe 123456789 2nd Street Dallas
Jane Doe 1 Main Street Dallas, TX 65654-4343
Jack Smith 234 W. Broadway Dallas, Texas 34212

Any idea how I can deconcatenate this without spending hours and hours?
Thanks for the help in advance.

--
Michael

On Mon, 23 Jun 2008 15:17:02 -0700, Michael <(E-Mail Removed)>
wrote:

>Hello,
>I need some help ASAP for any of you that can save me!
>
>In Excel '07, I have a cell with all of a persons contact info.
>
>Firstname MI Lastname Address Street State Zip
>
>Problem is there is no uniform structure. No tabbing, identifiers, and
>everything might not be included. For example:
>
>Jane M Doe 123456789 2nd Street Dallas
>Jane Doe 1 Main Street Dallas, TX 65654-4343
>Jack Smith 234 W. Broadway Dallas, Texas 34212
>
>Any idea how I can deconcatenate this without spending hours and hours?
>Thanks for the help in advance.

Can you make up a list of cities with all valid spellings? And also ensure
that none of the city names are identical with street names?

If so, then it might be possible.
--ron

It would take a significant amount of time. I have over 5000 rows

--
Michael


"Ron Rosenfeld" wrote:

> On Mon, 23 Jun 2008 15:17:02 -0700, Michael <(E-Mail Removed)>
> wrote:
>
> >Hello,
> >I need some help ASAP for any of you that can save me!
> >
> >In Excel '07, I have a cell with all of a persons contact info.
> >
> >Firstname MI Lastname Address Street State Zip
> >
> >Problem is there is no uniform structure. No tabbing, identifiers, and
> >everything might not be included. For example:
> >
> >Jane M Doe 123456789 2nd Street Dallas
> >Jane Doe 1 Main Street Dallas, TX 65654-4343
> >Jack Smith 234 W. Broadway Dallas, Texas 34212
> >
> >Any idea how I can deconcatenate this without spending hours and hours?
> >Thanks for the help in advance.
>
> Can you make up a list of cities with all valid spellings? And also ensure
> that none of the city names are identical with street names?
>
> If so, then it might be possible.
> --ron
>

On Mon, 23 Jun 2008 19:34:03 -0700, Michael <(E-Mail Removed)>
wrote:

>It would take a significant amount of time. I have over 5000 rows

You're probably out of luck then.

There does not seem to be any unambiguous method of separating the various
components.

You could identify the zip code as being a 5 or 5+4 digit string at the end of
the line.

You might also be able to use a lookup table to determine the state.

But I don't see any good method to separate the other information, given the
variability in your data.
--ron