Change character in Excel
Change character in Excel
- Subject: Change character in Excel
- From: Jay Young <email@hidden>
- Date: Sat, 23 Feb 2002 17:29:48 -0600
Does anyone happen to know if it's possible to change a character in
every cell of Excel all at once? For example, in Quark and other
applications you can run something like the following to change every
character of "a" to "b":
------------------------------------------------------
Tell app "Quarkxpress(tm)"
tell story 1 of text box 1 of document 1
set every character where it is "a" to "b"
end tell
end tell
-----------------------------------------------------
The only way I've figured so far is to run every cell through a repeat
loop. Just curious if there's a quicker way. Thanks for your help.
Jay
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.