Copying Word Table to Excel without Breaking one cell into multiple cells

I'm not sure if this is the correct forum for this question. If not, please let me know where i should post.

So, here's the deal. I'm pasting a column from Excel into outlook to run through a proprietary program from my company. It paste fine into outlook as a table (example spreadsheet). But when i try to copy and paste back into excel it breaks each line/sentence, from one of the cells in the table, into individual cells with a blank cell in between each row. I also need to keep the color formatting for the phone numbers in each cell.

I've tried find and replace (CTRL-H) to locate ^1 and replace with ^p, ^v, etc. then paste into excel and use the same method to replace ^p with nothing. Doesn't work. My brain is fried. I've been trying to figure this out for a few hours today and just can't seem to get it to work.

Any and all help is greatly appreciated.

Ok. So i added more cells to the example.

I export data from a program into excel. I'm trying to see who is a current client and who is not by their phone number.

Their phone number is buried within each cell. They are in various formats. so i can not extract all of them from each cell. These are the ones that i cannot. So, i need to run it through our system to figure out which are new and which are existing customers. Red are existing, purple are new. The system used to distinguished between the two is web based, so i paste the info into excel web app to run through our system until companies puts the finishing touches on the full version.

I then need to paste back into excel so i can filter by text color to separate out the two types of customers.

Does this help clarify?