prevent carrige return from being pasted
 

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