Hello -
I have a worksheet with a column that contains a date and time stamp (see example below). What I need to do is get rid of the time stamp leaving just the date information. I tried the formula =Left but because the number of characters in the date vary, this formula does quite work.
Example of what I have:
2/1/2013 10:41
12/21/2012 12:03
This is what I want:
2/1/2013
12/21/2012
Thanks in advance for the help!
Grilleman
assuming the date is in A1, you could try this:
=LEFT(A1,FIND(" ",A1)-1)
Hope this helps
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Hi Grilleman
Can you not just format as mm/dd/yyyy
Regards Kevin
Merged Cells (They are the work of the devil!!!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks