Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Character limit in cell
I am using Excel 97. Please note that I inherited this file.
I have a worksheet with data that I want to copy to a "new" workbook. Unfortunately, when I select the worksheet tab and select "move or copy" make my other selections, I am warned that data in some cells exceeds the 255 character limit and the data at the end will be truncated. The column in question stores comments (text). I know that cells have a character limit. But, if that is the case why can text be entered and still display everything that is entered; yet, Excel will cut it off if I used the worksheet tab to make a new workbook? Excel suggests using the copy/paste command to copy the data. This doesn't help to automate the process. Any suggestions? TIA Jan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count occurrence of character within a cell | Excel Discussion (Misc queries) | |||
How do I get a cell to show the fifth character of another cell? | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
number of character occurences in a cell | Excel Discussion (Misc queries) |