Clipboard paste special

I would like 2 things to happen
Paste from clipboard and remove returns (enters)
and only paste plain text no formatting (so it doesn't screw up my borders)

I want this to end up in one cell no matter how many lines are in the clipboard.

any help?
thanks

Paste the value into a temp cell (in this case it's cell A1 on Sheet1), remove any carriage returns (using the below code) and then copy and paste special --> values to your final cell.

Dion

Please Login or Register  to view this content.