+ Reply to Thread
Results 1 to 5 of 5

Remove extra data

Hybrid View

  1. #1
    Registered User
    Join Date
    04-28-2014
    Location
    Charlotte
    MS-Off Ver
    Excel 2013
    Posts
    6

    Remove extra data

    I am trying to remove the excess data.

    Ex.
    Fri Jun 27 10:06:16 EDT 2014
    I want to remove the Fri Jun 27 and the EDT 2014

    I want 10:06:16 left.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Remove extra data

    This could be a way to go.

    (there are although better options).

    Use text to column and after that delete the other columns.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Valued Forum Contributor TheCman81's Avatar
    Join Date
    11-06-2012
    Location
    Edinburgh, UK
    MS-Off Ver
    Excel 2003, 2007, 2010, 2013
    Posts
    346

    Re: Remove extra data

    Formula option, format cell as time

    =MID(A2,FIND(":",A2)-2,8)+0
    Excel Guru in the making

    <----------If the question has been answered to your satisfication please click the Add Repuation star to the left

  4. #4
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Remove extra data

    You could probably use Text-to-columns.
    This approach will replace the cell contents with only the time values
    • Select the single-column list of values to be impacted
    • Data.Text-to-columns
    ...Check: Fixed width....Click: Next
    ...Double-click break points to remove them...leaving only the ones on either side of the time value
    ...Click: Next
    ...Select the first column...Click: Do not import column
    ...Select the last column...Click: Do not import column
    ...If you want to place the time values in another location, select a Destination cell.
    ...Click: Finish

    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  5. #5
    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: Remove extra data

    Or this

    =TRIM(MID(SUBSTITUTE(MID(A2,FIND(":",A2)-2,255)," ",REPT(" ",255)),1,255))

    A
    B
    1
    2
    Fri Jun 27 10:06:16 EDT 2014 10:06:16
    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. Replies: 8
    Last Post: 08-27-2012, 04:37 PM
  2. Replies: 6
    Last Post: 06-12-2012, 07:50 AM
  3. Excel 2007 : Remove Extra Space
    By Jerseynjphillypa in forum Excel General
    Replies: 2
    Last Post: 11-08-2011, 12:09 PM
  4. Remove Extra Letters
    By day92 in forum Excel General
    Replies: 2
    Last Post: 01-20-2011, 07:20 PM
  5. Remove extra spaces
    By kanezfan in forum Excel General
    Replies: 1
    Last Post: 07-05-2007, 02:06 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