Re: Change character in Excel
Re: Change character in Excel
- Subject: Re: Change character in Excel
- From: David Emmons <email@hidden>
- Date: Sun, 24 Feb 2002 01:30:02 -0500
You should be able to get to Excel's built in Find and Replace function.
Here's what the Excel's Dictionary says:
Replace: search for and replace a string
Replace reference -- the range to search
What text -- the string to search for
[ReplaceWith text] -- found text will be replaced by this text
(after, look in and direction are not legal with this)
[LookAt xlWhole/xlPart] -- whether to look at whole or parts of
words
[SearchBy xlByRows/xlByColumns] -- search order can be row-major
or column-major
[MatchCase boolean] -- is case significant?
[Result: boolean] -- true, if successful
HTH
-Dave
>
From: Jay Young <email@hidden>
>
Date: Sat, 23 Feb 2002 17:29:48 -0600
>
To: email@hidden
>
Subject: Change character in Excel
>
>
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.
_______________________________________________
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.