So I have a column of cells that displays both the date and the time. i would like to extract just the date and put it into another column, but not the time. This could be because I want to use this information for further processing (maybe use it in a vlookup). Here is the best way to do it.
Mathematics & Digital Technologies Education
Videos, quizzes, and other learning resources
Eddie the Magic Monk has 16 years teaching experience as a high school teacher in Australia. He will explain things to you in the simplest way possible to help you fully understand high school mathematics and computer science concepts.
Eddie began his tutorial channel on Youtube in 2012. His videos have been well received all over the world and now has 22+ million views! He sees the benefit in multidisciplinary learning hence his tutorials cover topics ranging from maths to dance.