View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE.... max. limit 8 :(

Here's an old thread that might give you some ideas:

http://groups.google.com/group/micro...te_UK+*excel*#

(Besides, it not often that Harlan admits he screwed up !!)

Hope this helps.

Pete

On May 21, 9:47*am, wrote:
On 21 touko, 11:37, "Bob Phillips" wrote:

VBA. Have an Excel table of words and replacements, then loop through all of
the cells, then loop through the list checking for matches.


--
---
HTH


Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)


Now that is beyond my skills :(