1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Dates in Excel

Discussion in 'Business Applications' started by ktasker, Oct 2, 2009.

Thread Status:
Not open for further replies.
Advertisement
  1. ktasker

    ktasker Thread Starter

    Joined:
    Oct 2, 2009
    Messages:
    7
    Hey
    I have imported data from an outside database and it brought in the dates seperated. The information is in columns and the day, month (which is in text), and year each have their own cell. There are hundreds of dates. Due to space considerations I need each date to only take one cell. Is there any way to do this without having to do it by hand?
     
  2. The Villan

    The Villan

    Joined:
    Feb 20, 2006
    Messages:
    2,255
    Not sure which version of Excel you are using, but am assuming 2007. I will also mention what to do if you are using 2003 or earlier

    Create a blank worksheet and do the following so that you can see how the following formula works and then how to convert it as a value rather than a formula

    In A1 type 24
    In B1 type June
    In C1 type 1990
    In D1 type =DATEVALUE(CONCATENATE(A1,B1,C1))

    Assuming you have similar data in the Columns A, B and C, copy the formula in D1 down column D until you have a formula for each row of data in A, B, C

    Select all the formulas in column D and click on Home Ribbon tab ans click on the Copy Icon to place it in the clipboard. 2003 and earlier Edit, Copy

    Whilst those cells are still selected click on Home ribbon tab and click on the little down arrow just under the Paste button and select paste values. 2003 and earlier Edit, paste Special, Values OK

    Your data in column D will now be as a date (not a formula) which in the background is treated as a number, which then allows you to do calculations on the dates.

    Now select columns A, B and C and delete those columns

    You are now left with column A and the dates in single cells.

    Hope that helps
     
  3. ktasker

    ktasker Thread Starter

    Joined:
    Oct 2, 2009
    Messages:
    7
    Thank you this worked perfectly
     
  4. The Villan

    The Villan

    Joined:
    Feb 20, 2006
    Messages:
    2,255
    Glad it worked OK (y)
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Similar Threads - Solved Dates Excel
  1. BratDawg
    Replies:
    1
    Views:
    473
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/865468

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice