prevent carrige return from being pasted

B

Brotherwarren

Hi,

I have a problem I can't solve.

I have a list of comments written in a range in a shared workbook.

Individual users open the book and edit the comments, before saving
and closing.

The problem I have is that some users copy their comments from word.
Often they have used carriage returns to start a new line. This
causes half of the comment to be pasted into the correct cell, and the
rest to be pasted into the cell(s) below.

Is there a way to prevent this from happening?

Many thanks for any advice.

Tony
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top