Excel Quick Tips – How to convert dates from text using keyboard shortcuts

Excel Quick Tips – How to convert dates from text using keyboard shortcuts

HomeMatt BrattinExcel Quick Tips – How to convert dates from text using keyboard shortcuts
Excel Quick Tips – How to convert dates from text using keyboard shortcuts
ChannelPublish DateThumbnail & View CountDownload Video
Channel AvatarPublish Date not found Thumbnail
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.