Help: Reformatting worksheet: paste special challenge
 

Hello:

I'm trying to paste a single cell's text value into another. The original
has multi rows (separated by the line feed). They are pasting into multiple
rows. I want them in a single cell as the original. How to do this?

Thanks, Germaine

Paste into the formula bar instead of into the cell.
************
Anne Troy
www.OfficeArticles.com

"Bettergains" wrote in message
...
Hello:

I'm trying to paste a single cell's text value into another. The original
has multi rows (separated by the line feed). They are pasting into
multiple
rows. I want them in a single cell as the original. How to do this?

Thanks, Germaine

Thanks, Anne. I'll give that a try. I found out that I can also copy the
cell, whereas I had been copying the text from the formula bar.

"Anne Troy" wrote:

Paste into the formula bar instead of into the cell.
************
Anne Troy
www.OfficeArticles.com

"Bettergains" wrote in message
...
Hello:

I'm trying to paste a single cell's text value into another. The original
has multi rows (separated by the line feed). They are pasting into
multiple
rows. I want them in a single cell as the original. How to do this?

Thanks, Germaine