Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Transfering one cell of word to excel

when copying a cell witin a word table and pasting into excel, then
formatting the cell to wrap text, row column hieght, etc, when the cell is
deactivated, you can't see entire information. Is there a limit on the
characters? Is that the problem?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default Transfering one cell of word to excel

hi
yes there is a limit.
in xl help, type the word specifications. this will give you the specs and
limits of your version of excel.
length of text = 32,767 characters. Only 1,024 display in a cell; all 32,767
display in the formula bar

regards
FSt1

"WINDMILL" wrote:

when copying a cell witin a word table and pasting into excel, then
formatting the cell to wrap text, row column hieght, etc, when the cell is
deactivated, you can't see entire information. Is there a limit on the
characters? Is that the problem?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Transfering one cell of word to excel

You can see a lot more than the documented 1000 characters (or so) if you add
alt-enters (to force a new line within the cell) every 80-100 characters.



WINDMILL wrote:

when copying a cell witin a word table and pasting into excel, then
formatting the cell to wrap text, row column hieght, etc, when the cell is
deactivated, you can't see entire information. Is there a limit on the
characters? Is that the problem?


--

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
transfering data from word form to an existing spreadsheet Jose Excel Discussion (Misc queries) 1 October 15th 07 07:56 PM
Transfering a row of data to a template word or worksheet Marc Williams Excel Discussion (Misc queries) 1 October 27th 05 12:33 AM
Excel data not transfering to Word. Colums are expanded. carolsue1313 New Users to Excel 2 June 24th 05 08:16 PM
Transfering informationfrom one cell to another garr Links and Linking in Excel 5 February 21st 05 07:20 AM
transfering information from one cell to another garr Excel Worksheet Functions 8 February 21st 05 01:28 AM


All times are GMT +1. The time now is 06:25 PM.

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"