Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I change the number of characters per cell?
If pasting longer texts into cells, part of them gets lost. Use the Alt+Enter
for every cell could be the solution, but really painstaking one. Is there any way how to cancel this limitation or how to increase the default number of characters for all files? |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I change the number of characters per cell?
Lenoch, from excel help,
Cell content 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. but as you have found out, If you add alt-enters every 80-100 characters, you will be able to see a lot more than 1024 characters -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Lenoch" wrote in message ... If pasting longer texts into cells, part of them gets lost. Use the Alt+Enter for every cell could be the solution, but really painstaking one. Is there any way how to cancel this limitation or how to increase the default number of characters for all files? |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I change the number of characters per cell?
Thanks for the answer,
My problem concerns the export of data from Access to Excel. Access does not provide export of queries, so I tried €œTools-Office Links-Analyze It With Ms Excel€ to get the data in Excel. The problem is that longer texts were cut somehow off. Only about first 250-300 characters were imported. Have you got any idea where the problem is? Paul B pÃ*Å¡e: Lenoch, from excel help, Cell content 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. but as you have found out, If you add alt-enters every 80-100 characters, you will be able to see a lot more than 1024 characters -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Lenoch" wrote in message ... If pasting longer texts into cells, part of them gets lost. Use the Alt+Enter for every cell could be the solution, but really painstaking one. Is there any way how to cancel this limitation or how to increase the default number of characters for all files? |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I change the number of characters per cell?
Lenoch, I do not use Access and have no idea what might be causing this,
maybe somebody else will come up with and answer. -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Lenoch" wrote in message ... Thanks for the answer, My problem concerns the export of data from Access to Excel. Access does not provide export of queries, so I tried "Tools-Office Links-Analyze It With Ms Excel" to get the data in Excel. The problem is that longer texts were cut somehow off. Only about first 250-300 characters were imported. Have you got any idea where the problem is? Paul B píse: Lenoch, from excel help, Cell content 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. but as you have found out, If you add alt-enters every 80-100 characters, you will be able to see a lot more than 1024 characters -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Lenoch" wrote in message ... If pasting longer texts into cells, part of them gets lost. Use the Alt+Enter for every cell could be the solution, but really painstaking one. Is there any way how to cancel this limitation or how to increase the default number of characters for all files? |
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I change the number of characters per cell?
I ran into this recently while moving data from one Excel spreadsheet
to another using VBA. It appears the limitation is 255 characters. In Access you can look at the table design and deterimine if the field type is Memo (possible 65,535 char) or Text (max 255 char). If it is Memo then you would probably be better off manipulating the data in Access by creating a new query and then export it to Excel. You said that you can't export a query Access, but you can export the results to Excel. From Access: -Click File Save As/Export (Maybe File Export, Depending on the version of Access) -If you get the Save As/Export choose to external File and Click OK. -If you get File Export, next Step -You'll see the Export or Save As dialog box. In the "Save as type:" dropdown box at the bottom choose Excel. -Now click Export. HTH, Stan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I enter a 21 digit number in a cell & keep it from change | Excel Discussion (Misc queries) | |||
Number of characters in a cell (one row, merged columns) | Excel Discussion (Misc queries) | |||
Max number if characters in a merged cell | Excel Discussion (Misc queries) | |||
Change colour of Text if number in cell exceed limit | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) |