> OK, first of all, I wouldn't use ' as the delimiter as you might have a
> description something like "Hatton's Item" - paranoia, but it might
> happen
>
> Now here's where you're probably going to start kicking yourself at how
> easy this is
>
> objRange = objExcel.Cells;
> objRange.Replace("'", "");
>
> The objExcel.Cells says "We're working on all cells in this sheet"
> The objRange.Replace() has 2 main parameters, "from" an "to"
>
> That's it - it's really that simple <g>
(*sputters*) (*blinks*) You mean I spent 5 hours trying 30 different
ways and it's that easy?!
What I'm actually going to to is
ObjRange.Replace("#CHR(3)#", "'")
That way I don't run into anything that someone would have in a text field.
Thanks again!
Hatton
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
