How do I extract a common field and associate date automatically

Posted on 2014-07-14
Last Modified: 2014-08-20
In the attached spreadsheet I a cell (TOT/AVG) and a corresponding date that I need to extract into two coloumns (Date and Total)
Question by:cfhasan1

    Author Comment

    LVL 42

    Accepted Solution

    You can use the "Text to Columns" function.

    Highlight the cell in question and click text to columns.  Follow the prompts as indicated in the screenshots below


    Click ok to "Replace Destination cells..."

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
    Companies keep a much closer eye on costs today, so changing to new Technology – Microsoft Office 365 is the smartest move to take.
    An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now