> Just run the following one-line script in Script Editor, using whatever > character you want to replace instead of "f": > > > tell application "Microsoft Excel" > replace (used range of active sheet) what "f" replacement (return) > end tell > > > That will do a "Replace All" for the whole spreadsheet. If you want to > restrict it to just one column, for example column "C", do this: > > > tell application "Microsoft Excel" > replace (range "C:C") what "f" replacement (return) > end tell > > > or just in selected cells: > > > tell application "Microsoft Excel" > replace selection what "f" replacement (return) > end tell
Paul, thanks so much, this is literally non existent info in any docs I could find. Perfect. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- To unsubscribe: <mailto:[EMAIL PROTECTED]> archives: <http://www.mail-archive.com/entourage-talk%40lists.letterrip.com/> old-archive: <http://www.mail-archive.com/entourage-talk%40lists.boingo.com/>
