Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
indra
 
Posts: n/a
Default How to copy a cell to another sheet having more than 255 characte.

It is copying only first 255 character.. How to resolve this problem to copy
entire cell content
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default How to copy a cell to another sheet having more than 255 characte.

Copy from the formula bar

--
Regards,

Peo Sjoblom

(No private emails please)


"indra" wrote in message
...
It is copying only first 255 character.. How to resolve this problem to
copy
entire cell content


  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How to copy a cell to another sheet having more than 255 characte.

Copy the sheet the way you just did (ignore the warning). That way, you'll get
all the things that come with the sheet--page setup, event code...

Then go back to the original sheet, select all the cells, edit|copy and back to
the new sheet and paste over all the values (even the truncated ones).

indra wrote:

It is copying only first 255 character.. How to resolve this problem to copy
entire cell content


--

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
Nesting a sheet name reference within a cell reference??? Broyston Excel Discussion (Misc queries) 9 July 8th 08 08:35 PM
Copy an additional row based on another sheet Mindie Excel Discussion (Misc queries) 5 October 19th 05 02:47 AM
Clicking Cell Link Changes Cell on Another Sheet nshah Excel Discussion (Misc queries) 1 August 31st 05 01:50 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
how do i copy formula and change worksheet instead of cell dal0506 Excel Worksheet Functions 2 January 21st 05 08:41 PM


All times are GMT +1. The time now is 10:36 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"