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.
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.
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.
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
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?
Or this
=TRIM(MID(SUBSTITUTE(MID(A2,FIND(":",A2)-2,255)," ",REPT(" ",255)),1,255))
A B 1 2Fri 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks