• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 87
  • Last Modified:

Excel: Copy Text Range and Strip Out Table (For Outlook etc)


Attached is a sample Excel spreadsheet. Column A (yellow highlighted range) has some text across multiple rows. I would like the user to be able to be able to select this text and copy / paste it into Outlook. Currently if I do this, it's pasted into Outlook as a column of rows. I want to be able to paste it as 'normal' email text - formatting preserved.

I thought I could do this my creating a message box, however I can't select message box text to copy it directly to Outlook.

Is there another solution that allows me to copy and paste this text, preserve bolding - but strip out the table formatting?

1 Solution
Rob HensonFinance AnalystCommented:
When pasting into Outlook, choose Paste Special and select the Text option.
dabug80Author Commented:
Thanks. This is a good simple solution. It doesn't preserve the bold formatting - but apart from that it's great.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now