Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Hi, 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 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 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: 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? Thanks, Bo -- bxc2739 ------------------------------------------------------------------------ bxc2739's Profile: http://www.excelforum.com/member.php...o&userid=32538 View this thread: http://www.excelforum.com/showthread...hreadid=523549 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
exporting excel to csv large fields save as "####" | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Access -> Excel: How to export fields > 255 characters | Excel Discussion (Misc queries) | |||
Excel should be able to compute the MOD of large numbers. | Excel Worksheet Functions |