pasting, memory loss

[Chris Davison]

Aladin,

how do I get this back into excel ?

{"top left",1,2,3,4,5,6,7,8,"top right";1,2,3,4,5,6,7,8,9,10;2,3,4,5,6,7,8,9,10,11;3,4,5,6,7,8,9,10,11,12;4,5,6,7,8,9,10,11,12,13;5,6,7,8,9,10,11,12,13,14;6,7,8,9,10,11,12,13,14,15;7,8,9,10,11,12,13,14,15,16;8,9,10,11,12,13,14,15,16,17;9,10,11,12,13,14,15,16,17,18;10,11,12,13,14,15,16,17,18,19;11,12,13,14,15,16,17,18,19,20;12,13,14,15,16,17,18,19,20,21;13,14,15,16,17,18,19,20,21,22;"bottom left",15,16,17,18,19,20,21,22,"bottom right"}

thanks
Chris

 

[Aladin Akyurek]

Chris,

Copy it, activate a cell (in a sufficiently large, unused range), go to the formula bar, type =, paste it, and enter.

Go to cell where all this is, select a big enough range, hit control+shift+enter. Copy the selection and do Edit|Paste Special >Values. Clear the cells that contain errors.

Aladin

On 2002-03-09 06:05, Chris Davison wrote:
Aladin,

how do I get this back into excel ?

{"top left",1,2,3,4,5,6,7,8,"top right";1,2,3,4,5,6,7,8,9,10;2,3,4,5,6,7,8,9,10,11;3,4,5,6,7,8,9,10,11,12;4,5,6,7,8,9,10,11,12,13;5,6,7,8,9,10,11,12,13,14;6,7,8,9,10,11,12,13,14,15;7,8,9,10,11,12,13,14,15,16;8,9,10,11,12,13,14,15,16,17;9,10,11,12,13,14,15,16,17,18;10,11,12,13,14,15,16,17,18,19;11,12,13,14,15,16,17,18,19,20;12,13,14,15,16,17,18,19,20,21;13,14,15,16,17,18,19,20,21,22;"bottom left",15,16,17,18,19,20,21,22,"bottom right"}

thanks
Chris
/board/images/smiles/icon_smile.gif

 

[Chris Davison]

got it

thanks Aladin, much appreciated