No idea of how to solve your Excel problem.

However, if it's a CSV file, just open it in Notepad and do the replace there



"adibranch" wrote:


okay.. well here you go then.. a sample row of data in CSV. The line
breaks are inherent in the text.

ARRET100,ARROW ET100 240V HDUTY BRAD & NAIL GUN,55,TAXABLE
GOODS,18316,"ARROW ET100 240V HDUTY BRAD & NAIL GUN

Non-slip cushioned grip and superb balance assures effortless work,
even during long jobs. Specially angled channel to handle difficult
corner, edging and framing jobs. Provides nail driving muscle without
the burden of an air compressor. Shoots 3 different size beads.
Solid state circuitry.500 watts.
Hardened carbon steel delivery system for jam proof performance.
Trigger and surface contact safety locks combine to offer increased
years of safe, accurate trouble free service.

10 amps of power.
18 gauge beads available as follows:
ARRBN1810 Brad Nails 15mm Brown Head
ARRBN1812B Brad Nails 20mm Brown Head
ARRBN1816B Brad Nails 25mm Brown Head
ARRBN1816N Brad Nails 25mm White Head",Hand Tools,Soldering Riveting
and Tacking,Arrow,EOREOR

Basiclally i want to search all of the highlighted text field and
remove any instances of '

The file is fairly large with approcx 13000 rows. Oh and i'm using
excel 2003. I was simply trying a find/replace for the character ' and
replacing with a space.Whereupon i was getting the error 'formula too
large'.

Any more info you need?


--
adibranch
------------------------------------------------------------------------
adibranch's Profile: http://www.excelforum.com/member.php...o&userid=23670
View this thread: http://www.excelforum.com/showthread...hreadid=373450