Hi! I have a couple scripts that I would like to run on chunks of text in a single cell (A1). The problem I have is that often the text I copy has paragraph breaks so Excel likes to throw each line of text in a new row. Here is some example text:
Buddy you're a boy make a big noise
Playing in the street gonna be a big man some day
You got mud on yo' face, you big disgrace
Kicking your can all over the place
Singing
We will we will rock you
We will we will rock you
When I highlight cell A1 and paste the text, the first line appears in A1 but the second line starting with "Playing in the street" appears in A2. I would like the text to appear as a continuous string as below:
Buddy you're a boy make a big noise Playing in the street gonna be a big man some day You got mud on yo' face, you big disgrace Kicking your can all over the place Singing We will we will rock you We will we will rock you
I guess ideally, every paragraph break would just become a space.
Thanks in advance,
Cheers!
Buddy you're a boy make a big noise
Playing in the street gonna be a big man some day
You got mud on yo' face, you big disgrace
Kicking your can all over the place
Singing
We will we will rock you
We will we will rock you
When I highlight cell A1 and paste the text, the first line appears in A1 but the second line starting with "Playing in the street" appears in A2. I would like the text to appear as a continuous string as below:
Buddy you're a boy make a big noise Playing in the street gonna be a big man some day You got mud on yo' face, you big disgrace Kicking your can all over the place Singing We will we will rock you We will we will rock you
I guess ideally, every paragraph break would just become a space.
Thanks in advance,
Cheers!