Closed Thread
Results 1 to 2 of 2

Remove Duplicates and Multiple Rows into Single Cell with Commas.

  1. #1
    Registered User
    Join Date
    06-04-2014
    Posts
    3

    Exclamation Remove Duplicates and Multiple Rows into Single Cell with Commas.

    Hi There,
    Excuse my juvenility I am very new to programming.
    I need to remove the stop words (such as as, i, is, the) in the following data set.
    The strong of text needs to be no more than 80 words long as I will later be splitting this column into text-to-column format (thus 80 columns).
    Would it be beneficial creating a list of 80 Keep words instead of Stop words?
    How can I do this using Excel or Access?
    Many thanks
    Bree
    Attached Files Attached Files
    Last edited by bfitzpa; 06-05-2014 at 12:21 AM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,879

    Re: Remove Duplicates and Multiple Rows into Single Cell with Commas.

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Remove duplicates in a single cell
    By SonGoku in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-27-2013, 06:35 AM
  2. Multiple numbers seperated by commas in a single cell
    By abe10 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-26-2013, 05:42 PM
  3. [SOLVED] How do I combine multiple lines of information into a single cell, separated by commas?
    By ilostar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-22-2012, 11:48 AM
  4. Replies: 5
    Last Post: 06-05-2012, 03:32 PM
  5. Replies: 2
    Last Post: 04-03-2006, 05:50 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1