Excel 2013 /16 Short Cut Keys: Alt + AE (Text to column)

Text to Column

Microsoft Excel 2013 Short Cut Keys:  Alt + A+E
Hit the Alt key. Then type AE (one key at a time).

Text to Column
Split a single column of text into multiple columns.
For example, you can separate a columns of full name into separate first and last name columns.
You can choose how to split it up: fixed width or split at each comma, period, or other character.

No comments:

Post a Comment

Recommended for You


Related Posts Plugin for WordPress, Blogger...