Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
LINKED TEXT BOX
Hi,
i have merged a cell (about 10 rows x 10 columns) in order to type out text consisting of words, numbers etc. and have linked this cell to a text box in another sheet. i dont use any graphics but only letters and numbers. surprisingly, the linked text box appears to have only about 2/3rd of the text that i type. the full cell does not appear in the text box. how can i get the full cell to appear in the linked text box? i seek your assistance to resove this problem, please thanks stranger2excel |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
LINKED TEXT BOX
you will probably find that only 256 characters were transfered, if you count
them. this is a common problem. there are many entries in the discussion section on this, one method I have used is to copy as picture and paste the pictues into the new spread sheet, but not in a text box another way is to copy the cell paste it into word copy the word version and going to the excel text box pasting into the text box. unfortuanately, I do not know a specific formula to do this. "stranger2excel" wrote: Hi, i have merged a cell (about 10 rows x 10 columns) in order to type out text consisting of words, numbers etc. and have linked this cell to a text box in another sheet. i dont use any graphics but only letters and numbers. surprisingly, the linked text box appears to have only about 2/3rd of the text that i type. the full cell does not appear in the text box. how can i get the full cell to appear in the linked text box? i seek your assistance to resove this problem, please thanks stranger2excel |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
LINKED TEXT BOX
Hi BJ,
It worked, the Copy/Paste solution...... Best Regards "bj" wrote: you will probably find that only 256 characters were transfered, if you count them. this is a common problem. there are many entries in the discussion section on this, one method I have used is to copy as picture and paste the pictues into the new spread sheet, but not in a text box another way is to copy the cell paste it into word copy the word version and going to the excel text box pasting into the text box. unfortuanately, I do not know a specific formula to do this. "stranger2excel" wrote: Hi, i have merged a cell (about 10 rows x 10 columns) in order to type out text consisting of words, numbers etc. and have linked this cell to a text box in another sheet. i dont use any graphics but only letters and numbers. surprisingly, the linked text box appears to have only about 2/3rd of the text that i type. the full cell does not appear in the text box. how can i get the full cell to appear in the linked text box? i seek your assistance to resove this problem, please thanks stranger2excel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text box linked to cell | Excel Worksheet Functions | |||
Text in cell is cut off when linked to another WS | Excel Discussion (Misc queries) | |||
Linked text formatting | Excel Discussion (Misc queries) | |||
Text Box Linked To Cell | Excel Discussion (Misc queries) | |||
Text box linked to datasheet | Charts and Charting in Excel |