Splitting a string into characters

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

stringtrick.jpg

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

Leave a Reply