+ Reply to Thread
Results 1 to 4 of 4

Remove duplicate text from a cell

  1. #1
    Registered User
    Join Date
    03-27-2014
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    2

    Remove duplicate text from a cell

    I am using excel 2010 and need a formula to remove the duplicate text from a cell.
    In my excel the cell B1 is a list box with a list of text like "Apple, Banana, Grapes". When the user selects Apple, I have a formula in A1 which concatenates the text with whatever A1 has currently.
    In the starting A1 will have nothing. when user selects Apple in B1, A1 changes to "Apple", if the user selects again "Apple", the A1 is having "Apple,Apple". I wanted the A1 cell to have unique text always sorted alphabetically.

    Any help is appreciated.

    Thanks

  2. #2
    Valued Forum Contributor
    Join Date
    12-02-2012
    Location
    Melbourne, VIC
    MS-Off Ver
    Excel 2016
    Posts
    750

    Re: Remove duplicate text from a cell

    This sounds like circular referencing!
    From what cell will the user be selecting "Apple" the second time?

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Remove duplicate text from a cell

    Hi and welcome to the forum

    I have a formula in A1 which concatenates the text with whatever A1 has currently
    Umm no, sorry you dont. You can either have data in a cell OR a fomrula, you cannot have both.

    This is probably VBA code that is doing that, not a formula. I suggest you upload a sample workbook,showing wghat ou have and what you want
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    03-27-2014
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Remove duplicate text from a cell

    Yes, its a circular reference. The Apple will be selected again from the same B1 cell.

+ 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] Remove duplicate characters from a text string in a cell
    By sam99 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-22-2020, 06:10 PM
  2. Trying to remove duplicate text within a cell
    By ThatDamnRedhead in forum Excel General
    Replies: 11
    Last Post: 12-12-2014, 08:50 AM
  3. Macro to remove duplicate text within a cell
    By abramo in forum Excel Programming / VBA / Macros
    Replies: 37
    Last Post: 09-27-2013, 02:28 AM
  4. remove duplicate text within a cell
    By vitetor in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-31-2011, 04:24 PM
  5. Remove duplicate text in cell
    By jboomer in forum Excel General
    Replies: 7
    Last Post: 11-10-2009, 04:58 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