Copying text with paragraph marks into single Excel cell

When I paste text that contains paragraph marks into Excel it breaks the text
at each CR into a different cell. How can I force Excel to copy a body of
text, including CRs, into a single cell.

TIA

Peter

If you only have one cell to do, you can paste directly into the formula bar.

If you're copying a table (from MSWord???) to excel...

Saved from a previous post:

If your cells in your word table contain paragraph mark or linebreak characters,
then excel will bring them over as separate cells.

One way around it is to convert those paragraph marks & linebreaks to unique
characters, then copy|paste and then convert them back to linefeeds.

I like this technique (inside a copy of the word file):
Select your table.
Edit|replace|Special (show More if required)
Find what: (paragraph mark under Special button)
replace with: $$$$$ (if $$$$$ doesn't appear in the table)
replace all

Same thing with Manual Line break (from under Special).

Now copy the table into Excel.

Edit|Replace
Replace what: $$$$$
Replace with: hit and hold the alt and type 0010 from the number pad--not above
QWERTY.

It may look like you haven't done anything, but if you did it right, you
replaced $$$$$ with alt-enter.
Replace all.

Don't forget to close the word document without saving (or hit undo as many
times as necessary).

Peter Wells wrote:
>
> When I paste text that contains paragraph marks into Excel it breaks the text
> at each CR into a different cell. How can I force Excel to copy a body of
> text, including CRs, into a single cell.
>
> TIA
>
> Peter

--

Dave Peterson

I want to copy and paste RTF data to excel with html tags in the data applied
eg. <B><P>Data</P></B> converted to font with bold and paragraph style applied

like [P]Data[/P]


any code to convert these tags to vba code so that pasted values has those tags applied
Any help in this would be appreciated.
Thanks