1
Clipboard Help+Spell / Find and Replace Preset
« on: October 16, 2013, 06:07 PM »
In Excel:
I need to copy part of a column (several cells), and then paste the contents of those cells into one single other cell with the ALT-ENTER character between the value taken from each cell.
So if I had
A
B
C
in three cells, I need to paste A ALT-ENTER B ALT-ENTER C into a single cell.
Am I replacing a {TAB} character? And what would the ALT-ENTER character be?
Thanks,
Marty
I need to copy part of a column (several cells), and then paste the contents of those cells into one single other cell with the ALT-ENTER character between the value taken from each cell.
So if I had
A
B
C
in three cells, I need to paste A ALT-ENTER B ALT-ENTER C into a single cell.
Am I replacing a {TAB} character? And what would the ALT-ENTER character be?
Thanks,
Marty