Attached is an example.
Would like delete the HOURS (have no use for them, they interfere with the data).
Thanks in advance to all the people who help!
Attached is an example.
Would like delete the HOURS (have no use for them, they interfere with the data).
Thanks in advance to all the people who help!
Use
=INT(A1)
Copy down
Format as mm/dd/yyyy
Life's a spreadsheet, Excel!
Say thanks, Click *
several ways with that sample you could use find replace
find space* replace with nothing the format column mdy
or use text to columns
space as delimiter click next
select column with times in the window and choose do not import column(skip)
click finish
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
You can also remove hours by following these steps: highlight column with data, go to Data > Text to Columns, select space as delimiter, click next, here you will see 3 columns date, hours and PM/AM. click on hours and AM/PM and click on the radio button Do not import (Skip) and Finish.
Last edited by AlKey; 09-12-2013 at 06:25 PM.
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