B
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
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