Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell of sheet Not accepting 32767 character
hi all,
I am having problem related to excel sheet. Maximum character limit of cell in 32767. But when i try to add text containing those many character it is splitting some part into second cell. So my question is does it considering newline character as two chracters and counting limit along with that. Any help will be truely appreciated. Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell of sheet Not accepting 32767 character
If newline is just a line feed, then it's one character.
If newline is carriage control then linefeed it's two characters. What did you use? wrote: hi all, I am having problem related to excel sheet. Maximum character limit of cell in 32767. But when i try to add text containing those many character it is splitting some part into second cell. So my question is does it considering newline character as two chracters and counting limit along with that. Any help will be truely appreciated. Thanks in advance. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell of sheet Not accepting 32767 character
Hi,
thanks for your reply. I am using enter key to start new line means i am using new line and carriage return both. Bur then if that is case then it should not allow me to enter some more characters in same cell. When i copy past 32767 characters to cell it is not copying complete text. But then if after copy pasting i try to type remaining text in cell it is allowing me to type content into same cell until it reaches to 32767. For more information on this issue, just type 'a' characters 32767 number of times without any new line or any carraige return and then try to copy that text into excel sheet. You will notice that only 31767 charcters will get copied into cell. If you get any solution on this, please help me. This is very very argent for me as i have to do coding to store my text into two seperate cell depending on length of cell. Means in code what i am doing is taking first 32767 characters of text and storing that into first cell and then storing remaining charactesr into another cell. But as excel sheet is spliting 32767 characters itself into two seperate cell i am not able to find out solution for this. Any help will be truely appreciated. Thanks in Advance. Regards Archana. Dave Peterson wrote: If newline is just a line feed, then it's one character. If newline is carriage control then linefeed it's two characters. What did you use? wrote: hi all, I am having problem related to excel sheet. Maximum character limit of cell in 32767. But when i try to add text containing those many character it is splitting some part into second cell. So my question is does it considering newline character as two chracters and counting limit along with that. Any help will be truely appreciated. Thanks in advance. -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell of sheet Not accepting 32767 character
Hi,
thanks for your reply. but if i am copy pasting from somewhere else into excel worksheet, then at a time of getting length of that cell it should consider carraiage returns as well as line feed characters. And I tried with just typing character 'a' 32767 number of times in notepad without pressing any newline character. In this case also workbook not accepting those many charcters. I checked whether there is any newline charcater or not. But this text doesn't contains new line character. Ya you are right that if i try rept("a",32767) then it is filling cell properly but when i try to copy from notepad or word pad to excel cell, it is not working. Do you have any idea about this. Any help will be appreciated. Thanks in advance. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell of sheet Not accepting 32767 character
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Formatting text in cell (character by character) | Excel Discussion (Misc queries) | |||
excel 2003 print error number must be between 1 & 32767 | Excel Discussion (Misc queries) | |||
Protected sheet accepting values from List | Excel Discussion (Misc queries) | |||
Excel is not accepting any character entries | Excel Worksheet Functions | |||
Sheet Name Character String | Excel Programming |