« Basic functions: TEXT | Main | Datapilot Revisited »

August 18, 2005

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.

Posted by Dave at August 18, 2005 11:35 PM

Comments

Post a comment




Remember Me?