+ Reply to Thread
Results 1 to 2 of 2

Removing duplicates from a column with text strings

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2013

    Removing duplicates from a column with text strings

    Hi, I have a column of text from which I have removed duplicates using the usual method. Now the resulting column that I am left with can also have duplicate values as the data is not clean. Some of the inconsistency in the data is as follows:

    1) 'ABC (P2400)' in one row and 'ABC (2400)' in another row, which are essentially the same.
    2) 'ABC' in one row and 'Case ABC' in another row, which are same too.
    3) Inconsistency due to no. of spaces can also be there.

    The text in the cells is mostly a multi-word description of the product type.

    How do I obtain unique values from the column?

  2. #2
    Forum Expert sourabhg98's Avatar
    Join Date
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013

    Re: Removing duplicates from a column with text strings

    Please attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Counting Delimited Unique Strings and Removing Duplicates
    By The831st in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-30-2014, 11:51 AM
  2. Removing various different text, from varying length text strings
    By cloudwalking in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2013, 10:37 AM
  3. [SOLVED] How to remove duplicates from a column of strings
    By hennaleena in forum Excel General
    Replies: 4
    Last Post: 11-07-2012, 05:27 AM
  4. Replies: 4
    Last Post: 09-05-2011, 01:06 AM
  5. Finding duplicates inside text strings
    By snoopy1461 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-01-2011, 11:08 AM

Tags for this Thread


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