Help: Reformatting worksheet: paste special challenge

[Guest]

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

 

[Anne Troy]

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

 

[Guest]

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.