+ Reply to Thread
Results 1 to 4 of 4

Removing date from cells

  1. #1
    Registered User
    Join Date
    02-09-2015
    Location
    Newcastle, England
    MS-Off Ver
    2013
    Posts
    3

    Removing date from cells

    Hi,

    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:

    Red-01/01/2015-Jumper

    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
    08-04-2011
    Location
    UK
    MS-Off Ver
    Excel 2021
    Posts
    346

    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
    12-28-2014
    Location
    NSW, Australia
    MS-Off Ver
    MS365
    Posts
    604

    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
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Removing date from cells

    Another way with formula

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

    Row\Col
    A
    B
    1
    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

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