Hi,

I believe once the Excel cells/fields get too big (individual cell content size) some of the format
and find/search/delete functions, macros, and utilities seize to work become it is somehow truncated and
the entire cell doesn't even get processed. How do I go around this inherent limitation?

I'm currently using ASAP Utilities for Excel. What I use most
often is the "Advanced Character Removal" Tool under the Text Menu of
ASAP. It works great, However this Advanced Character Removal tool completely FAILS once the individual field/cell sizes become too large.Some of the cells in my Excel sheet have a LOT of Data (mostly memos,words,email transcript(s),etc) within each of the indivudal cells.

I have a bunch of 010 and 013 empty box characters and use ASAP to help me get rid of them, however ASAP fails to erase anything from cells that contain too much data. (Note: I have used VB MACROS to accomplish the same thing, and again here once the cells get too large the same thing happens, which makes me thing this is some kind of limitation/bug in MS Excel itself!)

IS there anyway around this????

Here's a link to my previos post for clarification:
http://www.excelforum.com/showthread.php?t=523214

Lots of ideas from people have helped a lot, but now I'm stuck with
having too large fields, and I can't compromise the size, so what to do?
Both the macros and the ASAP utilities fail to response to the individual contents inside the cells once
each cell contains too much data!? Why should this happen? Is there a way to remove the Excel limit??Thanks,
Bo


Excel fields too large to work with, any way around this?