Splitting a string into characters
Here’s a silly trick to split your string into separate characters across a range of cells.

You just need to enter the formula in C2 and then copy across the row as shown.
Here’s a silly trick to split your string into separate characters across a range of cells.

You just need to enter the formula in C2 and then copy across the row as shown.