Hi Excel Geniuses!
I'm looking for an easy formula to take the long form date and time from column A and simplify it in column B. My first idea is in row 1, to simply reference A1 and format the results as a date. The second idea is to reference A2 and take just the first 10 values and return them in B2.
Any suggestions on how to do either of those things?
<tbody>
</tbody>
Thanks for your help!
I'm looking for an easy formula to take the long form date and time from column A and simplify it in column B. My first idea is in row 1, to simply reference A1 and format the results as a date. The second idea is to reference A2 and take just the first 10 values and return them in B2.
Any suggestions on how to do either of those things?
A | B | |
1 | 2013-03-24T00:00:00-07:00 | 03/24/13 |
2 | 2013-03-24T00:00:00-07:00 | 2013-03-24 |
3 |
<tbody>
</tbody>
Thanks for your help!