Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How can I copy more than 255 characters in a cell without truncati

Hi

How can I (without the use of VBA) copy a large sheet where several cells
have more than 255 characters, without truncating the characters to a max of
255?

Thanks

Excel 2002 SP3
(This cannot be changed)
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How can I copy more than 255 characters in a cell without truncati

Copy the sheet and allow the truncation.

Then go back and copy all the cells and then paste over the new sheet.

(Same thing in vba, too!)

Gary Grung wrote:

Hi

How can I (without the use of VBA) copy a large sheet where several cells
have more than 255 characters, without truncating the characters to a max of
255?

Thanks

Excel 2002 SP3
(This cannot be changed)


--

Dave Peterson
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
How do I copy more than 255 characters per cell? JR Excel Discussion (Misc queries) 2 June 20th 07 08:40 PM
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 12:48 PM.

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

About Us

"It's about Microsoft Excel"