Wrap Text Excel Problem

[mashiling]

Dear Friends/Experts,

I have some issue with the excel 2007. Assume i already have some cells with information inside, and i have done the "wrap text" which make the paragraphs look neat in 1 line.

however, when i copy the cell info, and paste into any text editor, it looks to be the original format.

For example...
ORIGINAL
column1
row1 abc
def
row2 123

WRAP
column1
row1 abcdef
row2 123

BUT... after i copy row1 column1 to text editor,

it appears to be

abc
def

any method to solve this? so that it's still in 1 neat line?

Thanks a bunch, urgent help is needed!

 

[Richard Schollar]

I presume you must have a linefeed character in your actual cell values so you need to remove those before you do the copy - you could use a formula in another cell to generate the text to copy ie:

=CLEAN(A1)

 

[mashiling]

Hi,

I think you solve my problem! i have try a lot software and programs whole day!.........Thanks a bunch! BuMP!