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.
Bookmarks