Text to Columns: splits one column into several by a delimiter or fixed widths, and converts text numbers and dates on the way.

Windows

Alt, A, E

Mac

None

• Split by delimiter

  Select a column of "Last, First", Alt, A, E, Delimited, Comma, Finish → Two columns

  Split names.

• Convert text dates

  Select text dates, Alt, A, E, Next, Next, Column data format: Date, Finish → Real dates

  The fastest date conversion.

• Convert text numbers

  Select numbers stored as text, Alt, A, E, Finish → Converted to numbers

  One keystroke conversion trick.

• Set a destination cell so the original column is kept.
• TEXTSPLIT is the formula version in Microsoft 365.
• Fixed width handles legacy exports.

• Overwrites the columns to the right without much warning.
• Splitting on commas breaks addresses containing commas.