 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / July 2008multiple find replace
How can we do a whole list of words that shall be replaced with others column 1 = original word column b= new word any place in the even in the middle of a cell ex: is the apple pear orange yellow go white "is" shall be replaced we "the" we think this shall be with a v_lookup to work out On 7/30/08 1:15 PM, in article F7DB48F6-9480-4670-90DB-4D74CB0171D1@microsoft.com, "dk" > How can we do a whole list of words that shall be replaced with others > column 1 = original word column b= new word [quoted text clipped - 8 lines] > > we think this shall be with a v_lookup to work out Your best bet is to do multiple Edit-Replace. If you are using Excel 2004 or earlier, this can be done with VBA, or even AppleScript for the earlier and current version.  SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom We are using excel 2007, and we have about 100 words different words in several files > On 7/30/08 1:15 PM, in article > F7DB48F6-9480-4670-90DB-4D74CB0171D1@microsoft.com, "dk" [quoted text clipped - 14 lines] > earlier, this can be done with VBA, or even AppleScript for the earlier and > current version. On 7/30/08 10:38 PM, in article B7099219-C473-4629-BA49-82430C474B1C@microsoft.com, "dk" > We are using excel 2007, and we have about 100 words different words in > several files [quoted text clipped - 17 lines] >> earlier, this can be done with VBA, or even AppleScript for the earlier and >> current version. Well then your best bet is to write, (or have written) a macro that will do multiple replaces based on the list. Since you are using Excel 2007, your best bet will be to post to a Windows Excel forum. This one is for Macintosh Excel. SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.