+ Reply to Thread
Results 1 to 4 of 4

Remove date at end of every cell

  1. #1
    Registered User
    Join Date
    01-10-2023
    Location
    New York
    MS-Off Ver
    2021
    Posts
    2

    Remove date at end of every cell

    Hi Everyone,

    I am new to the site and very happy to be here. Thanks in advance for your help.

    I am looking to clean up two lists I have that both have the same problem. The first list is emails and the second is phone numbers and I need to remove the date in parenthesis that comes after them.

    Example:

    emailaddresshotmail(1/1/2023)
    emailaddressgmail(5/6/2010)
    etc......

    555-555-5555(10/5/2020)
    917-555-1234(12/12/2012)
    etc......

    Each list is in the thousands, so I need to clean it up with a formula or code but i do not know how.

    Any help is greatly appreciated.

    Thanks, Matt

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,422

    Re: Remove date at end of every cell

    Use
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    copied down.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    01-10-2023
    Location
    New York
    MS-Off Ver
    2021
    Posts
    2

    Re: Remove date at end of every cell

    Awesome, worked perfectly, thanks!

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,422

    Re: Remove date at end of every cell

    You're welcome.



    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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: 4
    Last Post: 06-06-2021, 12:17 PM
  2. [SOLVED] Conditional Formatting HELP to identify specific text, change cell colour & remove date.
    By Redders21 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-25-2020, 12:15 PM
  3. How to remove time stamp from cell with date
    By rayman741 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-05-2019, 02:40 PM
  4. Replies: 5
    Last Post: 01-02-2016, 10:51 AM
  5. [SOLVED] Remove specific text from a cell and than sort cells by month and date
    By Boo123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2014, 05:05 PM
  6. [SOLVED] How to remove date in one cell when another cell's contents are cleared.
    By jm263 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2013, 08:22 PM
  7. how to remove date from a cell
    By legolas in forum Excel General
    Replies: 2
    Last Post: 05-22-2008, 02:50 AM

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