Excel Quick Tips – How to convert dates from text using keyboard shortcuts
Channel | Publish Date | Thumbnail & View Count | Download Video |
---|---|---|---|
Publish Date not found | 0 Views |
Excel Quick Tips – How to convert dates from text using keyboard shortcuts
Get my FREE Ultimate Guide to Excel for Analytics here: https://www.tmbanalytics.com/excel-for-analytics-guide
Want to learn some useful Excel keyboard shortcuts? In this quick tutorial, I'll show you how to quickly convert a set of data formatted as text into actual usable data, using only the keyboard – no mouse required!
Select cells in column: Ctrl + Shift + Down Arrow
Move text in columns: Alt + A + E + F
This will activate the individual cells and change them from a date text to an actual date.
#Excel #ExcelTips #Analysis #Data #DataAnalysis #Hotkeys #ExcelShortcuts #Tmbanalytics #Nomouse
Please take the opportunity to connect with your friends and family and share this video with them if you find it useful.