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

Hi,

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?

Thanks.
ee-textstrip.xlsx
LVL 1
dabug80Asked:
Who is Participating?
 
Rob HensonConnect With a Mentor Finance AnalystCommented:
When pasting into Outlook, choose Paste Special and select the Text option.
0
 
dabug80Author Commented:
Thanks. This is a good simple solution. It doesn't preserve the bold formatting - but apart from that it's great.
0
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.

All Courses

From novice to tech pro — start learning today.