Wrap Text Excel Problem

mashiling

New Member
Joined
Aug 2, 2010
Messages
2
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! :(
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
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

New Member
Joined
Aug 2, 2010
Messages
2
Hi,

I think you solve my problem! i have try a lot software and programs whole day!.........Thanks a bunch! BuMP! :eek::LOL:
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,931
Messages
5,834,419
Members
430,284
Latest member
VikingScript

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top