Copy and Move sheet holding over 256 characters (Excel 2003 or 2000)

Topic

New Reply

HI LOUNGE,

Any one know a way I copy an existing spreadsheet I have into another workbook if the sheet I am copying has over 255 characters in each row?
currently when I use the right click on the sheet I want to copy check on create a copy and move to the a blank work book it loses the data in each row

Thanks ahead

Reply | Quote

Replies

Hi Markus

Just making sure I get this right, are you saying that all the cells in columns A:IV contain data (equaling 256 columns) and you want to export all rows?

Reply | Quote

What have create was basically a word document in excel. I have merge columns together (about 10 of them) and have typed in the merged columns I then adjusted the row and did a word wrap.

A new workbook was created and I want to add the worksheet from the previous workbook to the new one. When I use the move / copy worksheet method I am prompted and told the I have exceeded 255 characters and data will be lost. Just wondering if there was a way around being prompted about the 255 characters

Reply | Quote

The best you can do is copy the sheet, then go back, copy the old sheet’s cells and paste them into the new sheet.

Reply | Quote

Instead of copying the entire sheet, create a new sheet in the other workbook, then select all cells in the source sheet, copy them, and paste into A1 in the new sheet

Reply | Quote

Hi Marcus,

Have you tried doing a CTRL-leftmouse-drag on the worksheet tab you want to copy?

1. So you can see the two workbooks (source & destination) simultaneously, Choose Window | Arrange, then check either Vertical or Horizontal.
2. While pressing the CTRL key down, hold your left mouse down on the source worksheet tab, and drag the tab to next to any worksheet tab in the destination workbook.
3. Release your left mouse button, then the CTRL key.

That makes a duplicate of the source worksheet in the destination workbook and leaves the orginial in your source workbook.

Cheers,
Rich

Reply | Quote

Thanks, this method gives the same prompt though, 255 characters

Reply | Quote

A workaround.

Using string formulas find out the Length (Function Len) of each cell.
For those over 256 use string formula Mid to break up too long cells
By example

1. In a new empty cell put the formula =Mid(A1,1,255) where A1 references the cell that is too long
2. In a second new cell Mid(A1.256.511)
Continue until all text has been cut down
Then using copy then paste special turn the new cells from formulas to Values.
Latly delete the too long Text.
Now you can copy the Sheet to anywhere.
If you have a lot of work consider a Macro to repeat this task

Tom Duthie

Reply | Quote