Results 1 to 7 of 7

how to combine phrases - remove duplicates - and remove words with specific length

Threaded View

  1. #1
    Registered User
    Join Date
    06-30-2018
    Location
    Chicago
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    14

    Lightbulb how to combine phrases - remove duplicates - and remove words with specific length

    The problem I have is simple for a human to solve, but I'm having a hard time figuring out how to make excel do the same thing.

    I have phrases in each cell B2:F2

    ...and what I want to do is the following:

    take all of the individual words between B2:F2
    remove duplicate words
    remove words under 4 characters long
    take remaining words and post one word per cell between I2:R2

    I have en example in the excel file that shows the outcome I would like to have excel give.

    Thank you for the help
    Attached Files Attached Files
    Last edited by niktodorov1; 10-19-2018 at 02:34 PM. Reason: edit title

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Hard Excel Problem
    By simbalyon303 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2014, 08:09 AM
  2. Simple for you probably but hard for me
    By BrandonDassow in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 09-29-2011, 10:01 PM
  3. [HELP WITH ARRAY] Simple for you, very hard for me....please
    By Alex in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-15-2006, 03:55 AM
  4. Simple for you hard for me (newbie alert)
    By NathanS in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-15-2005, 01:05 PM
  5. Simple yet so hard. I need some help.
    By NavyAO1 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-23-2005, 09:13 PM
  6. [SOLVED] Simple data/Hard statistics
    By David in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-10-2005, 01:06 AM
  7. Simple data/Hard statistics
    By David in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-09-2005, 06:06 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