00:00If you have to split every single numbers into each individual cell or maybe each letter each
00:05individual cell this is how you do it first let's convert the number into a text like this cell b4
00:13and you're gonna press f4 three times like this to make it like that and i've limit my characters
00:18to be eight so i'm gonna say a wildcard of three four five six seven eight if you have more than
00:24that just change it accordingly so what this does is just converts that into a text now we're gonna
00:30use a function called mid the first argument of mid will be the text itself and the second argument
00:35we need a running number so basically we're gonna say column a1 which returns one and then comma one
00:41character at a time close parenthesis so basically what you have to do next is to drag it all the way
00:46across eight characters and you can see that it's splitting those texts into individual cells and
00:51this formula also works well with alphabet as well
Comments