+ Reply to Thread
Results 1 to 3 of 3

Issue with date extraction from other column

  1. #1
    Forum Contributor
    Join Date
    11-18-2014
    Location
    England
    MS-Off Ver
    365
    Posts
    132

    Issue with date extraction from other column

    I have a really annoying issue due to some stupid data that I have to work with - in column A there is a date and time - not in a proper excel format - this is how I get the data. I want to extract the date part only so do the formula in column b then use text to columns to force it into date format - however if the date is a month with 2 numbers such as Oct =10 (see last 2 rows) then my original formula drops the last digit off the date and the text to columns doesn't work - I have been resolving this manually nut I KNOW there must be a better way (other than changing the source data as that is outside my control)

    Any thoughts?

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,004

    Re: Issue with date extraction from other column

    Try this,

    B2
    =LEFT(A2,FIND(" ",A2)-1)

    copied down.

  3. #3
    Forum Contributor
    Join Date
    11-18-2014
    Location
    England
    MS-Off Ver
    365
    Posts
    132

    Re: Issue with date extraction from other column

    Thanks windknife, that does the trick perfectly, I knew there would be a better way!

+ 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] Date formula issue taking diff btw two date ranges
    By jw01 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-16-2022, 12:08 PM
  2. [SOLVED] If formula issue with date
    By ahvampire in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 02-02-2022, 06:43 PM
  3. [SOLVED] date formula issue
    By Tony0731 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-22-2018, 10:03 AM
  4. [SOLVED] date formula issue
    By Tony0731 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-21-2018, 11:57 AM
  5. date to formula issue
    By Todd6262 in forum Excel General
    Replies: 5
    Last Post: 11-28-2016, 04:25 PM
  6. Date Issue using a formula
    By Cremorneguy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-06-2014, 02:24 AM
  7. IF= formula date issue
    By jendew in forum Excel General
    Replies: 13
    Last Post: 05-12-2008, 03:17 PM

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