+ Reply to Thread
Results 1 to 5 of 5

Remove dublicate names from cell

  1. #1
    Registered User
    Join Date
    01-25-2018
    Location
    Athens
    MS-Off Ver
    Office 365
    Posts
    3

    Remove dublicate names from cell

    Hello Guys,

    Need some help

    How can I remove dublicate names from an excel cell (multiple cells)
    Attached Images Attached Images

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Remove dublicate names from cell

    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.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    01-25-2018
    Location
    Athens
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Remove dublicate names from cell

    Here you go ! Hope I make this more clear

    Thanks !!!
    Attached Files Attached Files

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Remove dublicate names from cell

    l2=IF(LEFT(C2,LEN(C2)/2)=RIGHT(C2,LEN(C2)/2),LEFT(C2,LEN(C2)/2),C2)
    Try this and copy towards down.

    Then copy data from Column L and pastespection>values in column C

  5. #5
    Registered User
    Join Date
    01-25-2018
    Location
    Athens
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Remove dublicate names from cell

    Man Thanks a Lot !!!!!

    I am very happy !!!

+ 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. How to remove certain names from a cell?
    By bethanyjoy10 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-15-2014, 06:34 PM
  2. Need to copy store names from sheet1 to sheet3 and remove duplicate names
    By aleanboy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-21-2014, 08:47 AM
  3. Replies: 1
    Last Post: 10-06-2014, 09:44 AM
  4. [SOLVED] Draw random names from list and then remove, carry on till no names left in list
    By dave1983 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-26-2014, 12:14 PM
  5. [SOLVED] Unable to remove names on cell groups for use in drop down lists
    By Allsort in forum Excel General
    Replies: 1
    Last Post: 08-14-2013, 02:00 PM
  6. Delete dublicate
    By nackgr in forum Excel General
    Replies: 2
    Last Post: 01-04-2011, 04:54 AM
  7. Replies: 5
    Last Post: 05-21-2010, 04:34 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