If I have data in a single column of about 50 rows, is there a way to output all those cells to a single cell, removing all spaces between rows? For example
A
1 Hello. My name
2 is Blinky. I like
3
4 to climb on things.
5 Give
6
7
8 me a banana!
9 EEK! EEK!
should be outputted to a single cell as:
Hello. My name is Blinky. I like to climb on things. Give me a banana! EEK! EEK!
A
1 Hello. My name
2 is Blinky. I like
3
4 to climb on things.
5 Give
6
7
8 me a banana!
9 EEK! EEK!
should be outputted to a single cell as:
Hello. My name is Blinky. I like to climb on things. Give me a banana! EEK! EEK!