Macro to extract specifc data [Closed]

Registration date
Sunday December 4, 2016
Last seen
December 4, 2016
So ive been tasked with creating a customer database. Our intranet has our customers listed by there name and then a email and phone number. Sad part is they never made the emails integrated into the software. (insert Office space pun)

So my plan is to manually copy the tables into excel. run a macro to clean up the unneeded data. extract the data and create a (.csv) file to upload into the address book.

here's the hard part. The data is a mess and doesn't always stay consistent.
good part is that the column A is always name and then B could be phone: fax: email: pager.

My main concerns are NAME an EMAIL. the phone number isn't priority.

I will attach a sample of what the data could come in looking like,

I have been searching the internet for ways to do this .tried to use what other have written and modified it but It never worked.

is there anyone who could point me in the right direction?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!