On 10/16/06 7:49 PM, "Scott Haneda" <[EMAIL PROTECTED]> wrote:
>> Control-option and return OR option-command return seem to put the newline
>> character inside an Excel cell.
>
> Thanks, managed to get that far, can not seem to find and replace with a
> newline though.
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 Berkowitz
--
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/>
