Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
JR JR is offline
external usenet poster
 
Posts: 92
Default How do I copy more than 255 characters per cell?

Is there a way to copy more than 255 characters in a cell when copying into a
new workbook?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How do I copy more than 255 characters per cell?

Make sure both workbooks are opened in the same instance of excel.

Open the first workbook anyway you want.
File|open the second workbook

Then do the copy|paste.

JR wrote:

Is there a way to copy more than 255 characters in a cell when copying into a
new workbook?


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,718
Default How do I copy more than 255 characters per cell?

The error message you get when you copy an entire sheet with this issue to
another workbook suggests that you copy the cells instead of or in addition
to copying the sheet. Doesn't this work?

This problem was fixed in Excel 2007, btw.

--
Jim
"JR" wrote in message
...
| Is there a way to copy more than 255 characters in a cell when copying
into a
| new workbook?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy all but last 9 characters of a cell Ben Excel Discussion (Misc queries) 6 April 17th 23 06:58 PM
Copy/paste from Win SQL gives strange characters Lars Excel Discussion (Misc queries) 0 May 29th 07 08:05 AM
How can I copy characters from a cell that follow a hypen brantty Excel Discussion (Misc queries) 2 April 3rd 07 08:42 PM
How to copy the cell contains above 255 characters from one sheet. Senthil Excel Discussion (Misc queries) 1 August 8th 06 04:48 AM
enter formula to copy characters in a cell less last one BC@D Excel Discussion (Misc queries) 1 April 5th 06 11:19 PM


All times are GMT +1. The time now is 03:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"