In this video, I show you two ways to split a string of text into individual columns.

Method 1: Enter text in column A & select the row. Go to the Data Tab – Text to Columns. Select Fixed Width & create breaks at each character.

Method 2: Enter text in column A. Paste this formula in each cell to the right until all text is separated into individual columns: =MID($A1, COLUMNS($A$1:A$1), 1)

This can be helpful when using my VLOOKUP method for solving a cryptogram as explained here: