Results 1 to 4 of 4

How to remove (specific) Stop Words from a Text? I'm absolutely not getting it (:

Threaded View

  1. #1
    Registered User
    Join Date
    05-18-2016
    Location
    Germany
    MS-Off Ver
    2016
    Posts
    2

    Question How to remove (specific) Stop Words from a Text? I'm absolutely not getting it (:

    Hi Guys,

    it costs me hours until now, but i'm not getting it. I'm not an experienced Excel user for this part and i hope you can help me.

    From my point of view, the task is easy.

    I have a Column (A) with a text. And I have a Column (C) with Stopwords in it.

    What should happen now?

    Excel should compare the two Columns and delete the Stop words found in Column (C) from Column (A). And always when I add some words to the
    stop word list (C) it should compare it with (A) again and delete it.

    I uploaded an Example file here.

    Maybe it's easier if the Stop Word list is on a separate sheet? I created one, if you need it. The Stop words are there the same like in the "text" sheet.

    Thank you so much!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [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
  2. Replies: 15
    Last Post: 10-12-2014, 08:53 AM
  3. Remove/Keep words in string of Text
    By bfitzpa in forum Access Tables & Databases
    Replies: 1
    Last Post: 06-05-2014, 12:55 AM
  4. Remove Stop Words from a column containing 16000 rows of sentences
    By Abhayrajify in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-30-2013, 07:14 PM
  5. How to remove two specific words from each cell in a column
    By pahari75 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-10-2013, 06:29 PM
  6. Remove specific words from cells
    By darkhorse4321 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-08-2010, 08:46 AM
  7. remove text after and before specific words
    By Statsman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-22-2008, 02:38 PM

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