Excel Quick Tips - How to convert dates from text using keyboard shortcuts
Excel Quick Tips - How to convert dates from text using keyboard shortcuts
Want to learn some helpful Excel shortcuts? In this short I show you how to quickly convert a series of dates formatted as text into actual, usable dates using only your keyboard - no mouse!
Select Cells in Column: Ctrl + Shift + Down Arrow
Cycle Text To Columns: Alt + A + E + F
This will activate each cell and change it from a date text to an actual date.
📢 NEW! Want my FREE Excel Daily Most Ultimate Guide? Grab it here: https://tmbanalytics.com/resources
🫵 Ready to take on the 7 Days to Excel Challenge?
👉 Click here if you dare: https://tmbanalytics.com/courses/7-da...
👉 Connect with me on social!
Linkedin: / mattbrattin
Tiktok: / mattbrattin
#excel #exceltips #analytics #data #dataanalytics #hotkeys #excelshortcuts #tmbanalytics #nomouse