+ Reply to Thread
Results 1 to 2 of 2

Removing duplicate words in individual cells

  1. 08-08-2014, 02:00 PM #1
    ypatel1990
    ypatel1990 is offline
    Registered User
    Join Date
    08-08-2014
    Location
    Southfield, Michigan
    MS-Off Ver
    MS 2010
    Posts
    2

    Removing duplicate words in individual cells

    Hello,

    I have a column that is filled with various car brands that a dealership might sell. The data in the cell may look like CHRYSLER; CHRYSLER; CHRYSLER which I would want to just say CHRYSLER. If the cell says CHRYSLER; FORD; CHRYSLER; FORD I want it to just say CHRYSLER; FORD. I was wondering if there was any way that is possible.
    Reply With QuoteRegister To Reply
  2. 08-08-2014, 02:12 PM #2
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Removing duplicate words in individual cells

    I suppose a user defined function could do this.

    Step through every word in the cell, find and remove duplicates.

    Simple in theory.

    Please Login or Register  to view this content.
    Last edited by mehmetcik; 08-08-2014 at 03:33 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Transpose each word in sentence into individual cells/Count the repeat words...???
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 12-21-2013, 02:38 PM
  2. VBA code to highlight individual changed words within Cells
    By marky571 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-07-2013, 09:23 AM
  3. Removing hyperlinks & copying web page tables to individual cells (rookie)
    By wingsavionics in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 09-27-2012, 02:23 PM
  4. removing words from cells
    By daddydoddy in forum Excel General
    Replies: 6
    Last Post: 06-24-2011, 07:30 PM
  5. removing duplicate words
    By mandi in forum Excel General
    Replies: 9
    Last Post: 07-16-2008, 07:37 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