Deleting/IDing Rows that Don't Meet Criteria

L

LittleAndLost

Biff is correct - the dates are text from an online database. I am no
sure of how to use the text to column function. Do you mind helpin
out?

Thank you for your quick response
 
B

Biff

Hi!

Select the data to be separated. Make sure the adjacent
column is clear or any data in it will be overwritten. You
can insert a new column if needed.

Goto Data>Text To Columns
Select Fixed width
Click Next
Point at and then double click the line separators that
divide the data. When you double click them, they will be
removed. Remove the first 2 and the last one. Your data
should look like this in the preview window:

August 19, 2004, | 7:19:35 PM
August 19, 2004, | 7:45:47 PM
August 19, 2004, | 8:30:31 PM
August 19, 2004, | 8:44:12 PM
August 19, 2004, | 8:46:12 PM

Click Finish

Now the times have been separated into a new column and
have been converted to true excel times.

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
countifs Function not giving desired result with date criteria 2
Countif with multiple criteria 4
Counting rows that meet multiple criteria 5
Creating list from values that meet multiple criteria from other sheet 1
Counting number of rows based on mutiple criteria 2
Deleting rows meeting certain criteria in a particular column 1
Function in Excel to count and list number of entries of text valuesin a row. 2

Top