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

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?

Bo,
I would like to try my XL Companion Excel add-in on the data.
Could you send me a sample sheet containing problem and non problem cells.
Remove XXX from my email address... [email protected]XX

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"bxc2739" wrote in message...
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?

bxc2739 wrote...
>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?
....

For some things, 255 chars are the most Excel can handle; for other
things, the limit seems to be 1,024 chars.

>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!)
....

FWIW, I start with the formula

=REPT("|"&REPT("----+----0",25)&"#",80)

which gives a string of length 20,160 chars. I copy the cell containing
this formula and paste special as values into some other cells. Excel's
own Edit > Replace to replace all # chars with nothing fails, but the
following macro works (in XL9 (2000) and later).

Sub foo()
Dim c As Range, t As String
For Each c In Selection
t = c.Value
t = Replace(t, "#", "")
c.Value = t
Next c
End Sub

Edit > Replace likely fails because it works with each selected cell's
..Formula property. If your macros are also using the .Formula property,
that's why they fail. Work with each cell's .Value property instead.