Only 50% date appears after cut and paste from one sheet to another

[oggsta]

I am pasting information form one spreadsheet cell to another cell, The cell incorporates approximately 50 words however when I cut into another spreadsheet with existing data, only half of the information appears, I have obviously tried to wrap the text and increase the row height but this has no effect, for some reason only approximately 50% of the data is being pasted over, there appears to be a control limiting the amount of date that can be pasted in to the existing spreadsheet.

Any explantion to why this happening would be appreciated.

 

[SkipVought]

Hi,

What is the length of the data in the copied cell and the pasted cell?
=LEN(A1)

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[oggsta]

Copied cell 755
Pasted cell 255

 

[carrr]

Max length of text cell contents in Excel is 255 characters....(

http://east.sd331.k12.id.us/teachers/larson/shared/excel_notes.htm)

Is the source spreadsheet Excel?

 

[SkipVought]

Hi,
You have run into a limit. 255 is 2^8 - 1.

Instead of copying the cell, f2-copy the contents and in the Edit mode (f2), paste it.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Poppy64]

Excel does have a limit of 255 characters per cell - although if you are using Excel 2000 you will see up to 32,767 characters shown in the formula bar.

Poppy64
Happy Troubleshooting...

 

[oggsta]

Both are excel spreadsheets are using excel 2000.
The spreadsheet with the data that is added to the other spreadsheet is actually generated from MS Access.

f2-copy the contents and in the Edit mode (f2), paste it. Didn’t appear to work as nothing was pasted in at all for some reason.

Both spreadsheets currently have cells with more than 255 characters prior to collating the data

 

[susejdrol]

One thought that comes to me mind is to link the cells rather thank copying them (click on the destination cell, hit the = sign, click on the source cell, hit <enter>), Then you can highlight the destination cells and tell it to copy and then paste special one the values.

My guess is that Microsoft may have one of their &quot;undocumented features&quot; that only lets you copy so much between sheets.

It is just a guess, but it may work.

Let me know what you find out.

CP

 

[KenWright]

Are you sure you are not trying to copy an entire sheet using the move/copy option. This will limit you to 255 copied characters in any given cell (And will usually provide a warning that it is doing so). The usual fix is to simply copy the affected range (Albeit the entire sheet if necessary - but not with the move/copy option) and then paste straight into the new sheet.

Regards
Ken....................

 

[Zathras]

I must be doing something wrong. I can't duplicate the problem with Excel 97 SR-1

Copy 1,036 characters...

cell to cell - ok
cell to input window - ok
cell to notepad - ok
notepad to cell - ok
notepad to input window - ok

Will someone please let me know the keying sequence to cause the truncation as described? (It might make a good bar bet.)

 

[KenWright]

Hi Zathras - I believe this only happens, regardless of version (currently anyway), when you have cells in a sheet with text that exceeds 255 characters, and you then try to use the 'right click on tab' and select 'move/copy' option to copy the sheet.

Regards
Ken.............

 

[Zathras]

Hey Ken, thanks. I've never tried that before.

When I do try it Excel pops up a message box explaining the problem and what to do about it better than anyone here has yet (in this thread):
[red]

The sheet you are copying contains cells that have more than 255 characters in them. Copying an entire sheet truncates cells that contain more than 255 characters.

To avoid truncation, copy the cells of the source sheet to the destination (rather than copying the entire sheet).

[/color]
I guess oggsta doesn't bother to read messages when they appear.

 

[KenWright]

LOL - Zathras, I'm hurt!!

Zathras scribes:-
>When I do try it Excel pops up a message box explaining >the problem and what to do about it better than anyone >here has yet (in this thread):

Ken had scribed:-
>Are you sure you are not trying to copy an entire sheet >using the move/copy option. This will limit you to 255 >copied characters in any given cell (And will usually >provide a warning that it is doing so). The usual fix is >to simply copy the affected range (Albeit the entire >sheet if necessary - but not with the move/copy option) >and then paste straight into the new sheet.

Regards
Ken..............