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.