| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing text--cell text limit?
I'm importing text via the wizard. Some strings are greater than 1027
characters in length. When the strings exceed 1027, they are truncated. Is there a way to modify the cells to allow longer strings? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Importing text--cell text limit?
hi
in xl help type the word specification. this will give you the spec and limits of your version of excel. 2003 cell will hold 32767 characters but only 1024 show in the cell. all 32767 show in the formula bar 2007 same as above but not sure about how many will show in the cell. i assume the same. no way to adjust this....hard coded into excel. specs and limits. Regards FSt1 "Scout" wrote: I'm importing text via the wizard. Some strings are greater than 1027 characters in length. When the strings exceed 1027, they are truncated. Is there a way to modify the cells to allow longer strings? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I limit the amount of text in a given cell? | Excel Discussion (Misc queries) | |||
| How do I remove text limit on a cell | Excel Discussion (Misc queries) | |||
| limit text length after importing data | Excel Worksheet Functions | |||
| Limit of text in cell. | Excel Discussion (Misc queries) | |||
| Is there a limit on amount of text that can go into a cell? | Excel Discussion (Misc queries) | |||
Hybrid Mode
