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