Hi all,

I want to drag and drop text from my email client (Outlook 365) into Excel. The text contains hyperlinks and plain text. Keeping the formatting is not essential, but maintaining the integrity of the link is essential. Here is the real problem: is there a way to copy and paste everything into a SINGLE cell. Excel's default formatting seems to place all new lines of text into separate cells down a column, and (most annoyingly) places hyperlinks into their own cell. My brief internet search seems to suggest that it is not possible to override Excel's basic copy/paste formatting, but I though I would throw this to the community.

Thanks!