Finding & Extracting Senders Information (Name, Street Address, City, St, Zip) in the cell's content

[Chuckdee]

Hello,

Total Novice here who has come up with an interesting problem.

What if I import all received emails into excel and the body of the email (the message) were put into a cell and I wanted to extract only the senders Information (Name, Street Address, City, St, Zip). The problem I have found is that senders all sign off differently (Sometime nothing, Thank you, Best, sincerely, etc.) So, this poeses a problem in finding this information.

So here is the challenge, (based on what I have below)

The issue:

How can I pull both the senders’ info below, in the body and also from the salutations at the end?

• How do I find this information within the context of the cell?
• Once found, how do I then copy that information into its own column (Name, Street Address, etc.)?
• What do I do if information found does not have everything (Name, Street Address, etc.), meaning what if one of those elements are missing?

Been trying to solve this since a week ago this past Sunday and I am at my wits end trying to come up with a way to solve for this, so any help is appreciated,

Thanks


Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah and be sure to visit our office anytime at 1234 Some St., Dallas, TX 22322. Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah, Blah

Joe Sort
Blah Corp
456 Other Street
St Louis, Mo 11111
Cell: ###-###-####

 

[JvdV]

Very tricky. Maybe your best bet is a regular expression to catch a pattern that would capture these parts, however; the very nature of free formed text is that you may need quite the intrigate pattern before you capture what you really want and even then I'm not sure you'd always get what you expect.

 

[Chuckdee]

Very tricky. Maybe your best bet is a regular expression to catch a pattern that would capture these parts, however; the very nature of free formed text is that you may need quite the intrigate pattern before you capture what you really want and even then I'm not sure you'd always get what you expect.

Thank you for the reply, really appreciate it.