With the data s ected, and triggering this functionality, a wizard steps you through the process of converting the selection into columns.
It’s called Text to Columns, and can be found on the Data tab. Now there’s a handy feature in Excel that will let us transform that data and move the comma separated fields out into separate cells. Let’s start with a similar set of data, but let’s have it separated by commas rather then tabs. Well the issue turned out to be related to some text processing I’d been carrying out earlier. The effect I got when actually pasting the data however was rather different and the format came out with the data being compressed into one cell on each row.Īll of the cell data was being compressed into single cells per row, and the tabs were effectively being stripped out. When that gets pasted into Excel in cell A1 of a worksheet, I would typically expect the results to come out like so.
0 kommentar(er)
