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: https://youtu.be/voU7PmbNa48