You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.
Any action you wish to apply on a cell requires the cell to be selected first. Normally, you just click a cell or drag your mouse across multiple cells. However, if you did not capture the entire area ...