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

[bxc2739]

Hi,

I believe once the Excel cells/fields get too big (individual cel
content size) some of the format
and find/search/delete functions, macros, and utilities seize to wor
become it is somehow truncated and
the entire cell doesn't even get processed. How do I go around thi
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 too
completely FAILS once the individual field/cell sizes become to
large.Some of the cells in my Excel sheet have a LOT of Data (mostl
memos,words,email transcript(s),etc) within each of the indivuda
cells.

I have a bunch of 010 and 013 empty box characters and use ASAP to hel
me get rid of them, however ASAP fails to erase anything from cells tha
contain too much data. (Note: I have used VB MACROS to accomplish th
same thing, and again here once the cells get too large the same thin
happens, which makes me thing this is some kind of limitation/bug in M
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 t
do?
Both the macros and the ASAP utilities fail to response to th
individual contents inside the cells once
each cell contains too much data!? Why should this happen? Is there
way to remove the Excel limit??Thanks,
Bo


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

 

[Jim Cone]

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... (e-mail address removed)

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



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?

 

[Harlan Grove]

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.