+ Reply to Thread
Results 1 to 3 of 3

Remove duplicate strings from single cell with line breaks

  1. #1
    Registered User
    Join Date
    06-26-2014
    Location
    Queensland, Australia
    MS-Off Ver
    2016
    Posts
    35

    Smile Remove duplicate strings from single cell with line breaks

    I'm hoping someone can help with this.

    Is there any way to remove (with formula) the duplicate stings from a single cell with strings separated by line breaks?

    I've a attached an example of how the output should look.

    Many thanks
    Attached Files Attached Files

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Remove duplicate strings from single cell with line breaks

    with UDF:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    06-26-2014
    Location
    Queensland, Australia
    MS-Off Ver
    2016
    Posts
    35

    Re: Remove duplicate strings from single cell with line breaks

    This is perfect and works brilliantly! Thanks so much

+ 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. Replies: 1
    Last Post: 09-04-2015, 04:48 AM
  2. Replies: 8
    Last Post: 03-10-2015, 01:05 AM
  3. [SOLVED] MultiLine Textbox to auto remove blank line, count line, remove duplicate
    By khhoa in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-24-2015, 09:28 PM
  4. Replies: 8
    Last Post: 07-14-2014, 03:07 AM
  5. Replies: 1
    Last Post: 03-18-2014, 06:57 PM
  6. Remove duplicate data in single cell
    By GenericPat in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-20-2012, 12:32 PM
  7. Remove Certain Line Breaks in cell
    By hollyc2424 in forum Excel General
    Replies: 1
    Last Post: 05-18-2011, 01:47 PM

Tags for this Thread

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