255 Charactor per cell

[adeel via OfficeKB.com]

I have large quantity of data sheet. I am trying to making copy of this sheet.
I am doing this : Right Click on sheet tab > Move or Copy > check on creat a
copy box > ok. An error message occurred saying " The sheet you are copying
has cell that contain more than 255 charactor...................."

Please some one tell me the alternate mathod of making copy of sheet that
contain cells which have more than 255 charactors.

 

[Ron de Bruin]

Hi Adeel

Add a empty sheet or copy the sheet like you do now.
Go back to the sheet with the data
Select all cells (Click on the space above the first row header and on the left of the first column header)
Ctrl C
Go to the new sheet
Select A1
Ctrl V

 

[Ron de Bruin]

Btw: This is fixed in Excel 2007