Results 1 to 4 of 4

Substitute word by list

Threaded View

  1. 02-04-2019, 11:05 AM #1
    vasc
    vasc is offline
    Forum Contributor
    Join Date
    10-18-2017
    Location
    london
    MS-Off Ver
    2007
    Posts
    152

    Substitute word by list

    My friend,

    how put a black list in next excel file?

    column I and N contain prohibited word


    all formula is in the file for function with two word, but increasing number of word increasing the number of column.
    ideas?

    thanks again
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA script to substitute text from an excel sheet into various word docs by filepath
    By tomca in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-09-2021, 05:57 PM
  2. Substitute using a named list
    By Hnorgaar in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-03-2018, 03:13 AM
  3. [SOLVED] Is there another way to write INDEX(INDIRECT(SUBSTITUTE()),MATCH(OFFSET(SUBSTITUTE()))?
    By keby1nko in forum Excel General
    Replies: 4
    Last Post: 10-28-2014, 11:04 PM
  4. [SOLVED] Need a formula to find and substitute a word in a text if a condition is met...
    By danielneedssomehelp in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-18-2014, 01:34 PM
  5. [SOLVED] How can I replace a word from a sentence in a cell & substitute word from another cell
    By rionoah in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-11-2012, 08:44 AM
  6. SUBSTITUTE word in multiple cells
    By WEEZY760 in forum Excel General
    Replies: 5
    Last Post: 03-22-2012, 03:02 PM
  7. How to Substitute a Singular/Plural word to nothing in an Alphanumeric Text..?
    By e4excel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-01-2010, 06:14 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1