|Here is a sample of what is contained in a few of thousands of cells. 80% have the name at the beginning, some with middle initials, usually followed by a space or comma after the name. Most of the other 20% have "NAME:" or "name:" before the names. The rest of the info I need(phone # & email) are scattered throughout the data in the cell. The phone numbers are written out usually as (111) 222-3333 or 111-222-3333 or 1112223333. There is usually a fax number in the data as well in the same format but would usually have "Fax:" in front. The email addresses are in no standard format as some have just first and last names separated by a period, some have middle initials, etc. Almost all email addresses have .mil at the end. Some cells have more than one person's email address, but I am only looking for the email of the person at the beginning of the data in the cell.|
Is there any hope of a formula to extract this data (name, phone, email) into 3 separate columns without cutting and pasting each? Thanks!
Eli L Rorter, Phone 591-621-4412, Fax 591-621-4319, Email firstname.lastname@example.org
Hank D Wilson, COUNSEL, Phone 591-621-4405, Fax 591-621-4419, Email Hank.Wilson@dk.ngb.army.mil
NAME:Tammy Peters, 205-252-4408 a href="mailto:email@example.com"USO for Al</a <tim whitters, (205) 252-3393, firstname.lastname@example.org