00:00How do you get from this to this, where each character on a text string is placed on a separate
00:05column?
00:05Well, this is how I do it.
00:07We start off with using a mid function, which extract character from a text string.
00:10The first argument is going to be B3, where the text string is located.
00:14And the second argument is the start position.
00:16Let's place it to a fourth position.
00:18And the third argument is the number of characters to extract, which is going to be one character per column.
00:22As you can see, it returns the value of N, which is the fourth character.
00:26If you change it to 5, you get L, and I, and so on.
00:30We need the second argument, the position of the text string, to sequentially increase up to the length of the
00:35string.
00:36So we use a sequence function with the argument of 6, which gives us the first 6 character, but we
00:41need it for the entire length of the text string.
00:43So we use a length function and B3 as an argument.
00:48After that, we flip it to a horizontally using a transpose function and apply the same formula for the rest
00:53of the rows.
00:56So we notice this will take a couple of hours trying to follow.
Comments