Whenever you copy a cell (CTRL+C), Excel automatically appends a line
break at the end. This makes it impossible to paste the cell directly
into a single-line text field.
Can you copy an Excel cell without the automatic line break?
Is there a hidden line break in the cell that I can remove?
Is there way I can get Excel to place the result directly in the
clipboard without the automatic line break?
Is there a way I can get VB to interface with Excel so that I can get a
copyable field that doesn't contain an automatic line break?
Bookmarks