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

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
0
dabug80
Asked:
dabug80
1 Solution
 
Rob HensonIT & Database AssistantCommented:
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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