Results 1 to 21 of 21

Remove words by substring list

Threaded View

  1. #1
    Registered User
    Join Date
    03-12-2022
    Location
    Bucharest
    MS-Off Ver
    2019
    Posts
    35

    Question Remove words by substring list

    How to remove or replace familiar words in string, by list of familiar stubs of that words?
    List contain ~30 stubs (substrings). With all of this I expect substitute hundreds matching words.

    dOAb3.png

    Attention! Some words contain two different stubs, and this can create conflict in substitution.
    I suggest to use case insensitive functions to exclude double length of formula.
    I think is better to replace/substitue, instead of delete/trim because in that way we can meke correction in word, not just trimming.

    I post in Formula thread because I prefer only excel formula, without vba or power query and without helper columns.
    But any suggestion is helpful for different types of users, not only for me.

    Here is the workbook:
    Attached Files Attached Files
    Last edited by Losai; 03-14-2022 at 04:51 AM. Reason: Accuracy

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to Remove Certain words automatically from Excel
    By drp99246 in forum Excel General
    Replies: 1
    Last Post: 03-16-2019, 01:34 AM
  2. [SOLVED] Find matching words in a text string and return one of four words
    By alecoute in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-12-2018, 12:33 PM
  3. Replies: 6
    Last Post: 10-19-2018, 02:44 PM
  4. remove words and get result in other cell in excel
    By notbanme in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-23-2016, 05:31 AM
  5. [SOLVED] Macro to remove 650 stop words from excel text
    By PiaHarrison in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-18-2016, 03:56 PM
  6. [SOLVED] Remove duplicate rows by matching values across columns in Excel 2007
    By guest2013 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-15-2013, 12:00 AM
  7. [SOLVED] Find matching words in 10 columns and add row numbers of matching words
    By zeke 29 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-03-2012, 09:57 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1