Even when you format the cell to "wrap text", it does not seem to engage this thought though it will no longer spill to the right. So it seems to never reach the point where it would even consider changing the row height. It seems to desire to display it off to the right as a single line line covering columns to the right until encountering a filled cell. That will paste it all into the single cell, period, no splitting it between cells possible for Excel.Ī final note is that it usually will not change the row height to match the pasted material. If you only have a single paste, or a couple, and don't want to bother with that, you can copy the material, come back to Excel, then press F2 to enter the cell edit mode and paste the material directly into the formula bar (or whatever, if you use the horrid "edit in the cell" feature.). Until one uses the wizard for something and checks any of the boxes. That's the fix that lasts more than one paste operation. ![]() Then click Cancel to quit without tearing that poor cell's data up, and you are good to go. Of course, if Tabs could be in your text, uncheck that as well. And one might have something else in the "Other" part that could cause trouble. ![]() Of course, that's because one seldom encounters Tabs INSIDE a paragraph so it's usually OK, but one DOES encounter commas and spaces, even semicolons so they will cause the Paste function to break up the data resulting in the multiple lines you encounter. Experience says "Tab" can be checked and things work fine, but the rest need to be unchecked. Look at the list of delimiters they show. Make sure Delimited is selected and click Next. To clear the problem up, pick some cell with data in it and open the Text to Column wizard. However, using the F2-Edit approach mentioned further down, you CAN paste only the text into the cell, no formatting string at all.) This seems to be its designed approach and is not affected by the below. (I will make a note here, that with formatted HTML data, Excel will paste the formatting material on one line and the textual material on the line underneath. ![]() if you copied three paragraphs, you SHOULD expect it to end up in three cells), Excel's Text to Columns wizard is at the root of the problem. It's a very odd thing, but when you paste something like this in Excel and it fills out multiple lines for a piece of text that is one entity (your paragraph is a single entity for this purpose.
0 Comments
Leave a Reply. |