Originally Posted by
supermario2k8
Sorry, I really have no idea how to word this so haven't had any luck with google or searching here...
What I need is to be able to paste a whole bunch of data into a single cell, and then for it to be organised into columns and rows etc etc
....snipped
Is it possible?
Yes it's possible, up to a point. There's a limit on the number of characters you can have in a cell - I think it's slightly variable but circa 1000, but no doubt someone will comment if not.
Given that caveat, and certainly with your example data, I managed it by doing the following.
1. Paste that string into cell A1.
2. Perform a Data-->Text to Columns using the delimited option and tick the space box. When you get to the bit where you can specify the column data format, select all the columns and choose the Text option.
3. Assuming you have now split everything across the columns in Row 1, use the following formulae"
in A3
In B3
In C3
Now copy A3:C3 and copy down.
HTH
Bookmarks