+ Reply to Thread
Results 1 to 4 of 4

Removing date from cells

  1. #1
    Registered User
    Join Date
    Newcastle, England
    MS-Off Ver

    Removing date from cells


    I'm hoping someone can help with this problem. I would like to know how to remove the date and hyphens (in red below) from within a cell that also includes other information, like so:


    If it was only one or two cells then I would happily manually delete the information, but there are several hundred rows of this instance.

    Thanks in advance for any help given.

  2. #2
    Valued Forum Contributor
    Join Date
    MS-Off Ver
    Excel 2013

    Re: Removing date from cells

    if your data always the same format, try this with data in A1;

    =REPLACE(A1,FIND("-",A1),12," ")

    replace the " " of your choice

  3. #3
    Valued Forum Contributor
    Join Date
    NSW, Australia
    MS-Off Ver

    Re: Removing date from cells

    Hi graisbeck, insert a column beside the column in question and enter the following formula (change A1 to suit actual cell)
    Please Login or Register  to view this content.
    That will make your sample show RedJumper
    If you need a space, as in Red Jumper, then:-
    Please Login or Register  to view this content.
    If you want to make it permanent then select the column, click copy, then paste special - values, and that will replace the formulas with the resultant text.
    Then you could delete the original column if you wish.

    Edit:- OK, AlanY's is much much better

    I refresh the webpage before I post to make sure someone else hasn't replied, nothing there so I post, then I see all new posts..very annoying.
    Last edited by Beamernsw; 02-09-2015 at 10:58 AM.

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365

    Re: Removing date from cells

    Another way with formula

    =SUBSTITUTE(A1,MID(A1,FIND("-",A1),12)," ")

    Red-01/01/2015-Jumper Red Jumper
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ 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. Removing Duplicates between two cells reliant upon the formatting of the two cells
    By bethanj93 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-04-2014, 03:59 AM
  2. Replies: 4
    Last Post: 04-30-2014, 12:42 PM
  3. [SOLVED] Removing "0" Value from cells before applying Date Format
    By ghostly1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-17-2014, 02:08 PM
  4. [SOLVED] Removing day from the date cells?
    By nanomess in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-14-2013, 05:44 PM
  5. dates on/after 09/01/2011 are removing date from other cells
    By SnowblindMonkey in forum Excel - New Users/Basics
    Replies: 16
    Last Post: 01-09-2011, 05:43 PM


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