Excel has a per-cell character limit.

written by daniel on August 15th, 2008 @ 04:38 PM

Note: Excel (on a 32-bit system) has a limit on the number of characters (bytes) per-cell that is somewhere around 32,000. NeoOffice’s limit (on a 64-bit system) is around 64,000. Careful when you’re shoving large amounts of text into a file.

This public service announcement has been brought to you by Frustration, and Debugging a CSV Exporter.

posted in:

tags:

, , ,

comments are closed

2 comments

Comments

  • dreamhost promo code on 19 Aug 00:50

    I am not sure about limit, but I was wondering if there is a way to use Excel to open a CSV file separated by ^ such that some cells contain new lines (\n) ?

  • joseph on 10 Nov 19:49

    i want to write these 2 lines into a single cell.

    example: The lion is in the field The bird is in the tree

    BOTH LINES IN A SINGLE CELL ? THANKS

Post a comment

Options:

Size

Colors