deconcatenate

[Michael]

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.

 

[David Biddulph]

Please don't multi-post.
And the answer is no.

 

[Ron Rosenfeld]

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

 

[Michael]

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

 

[Ron Rosenfeld]

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