Another quick spreadsheet to show off the capabilities of Excel.
Site visitor Jamie left the following comment on my recent post, “Random Number Generator for Excel“:
maria dont spose u know how to split a four digit number like 2365 into 4 different numbers 2 3 6 5 in all different cells in excel without having to do it manually just wandering please tell me if you know a way thanks
I had an idea of how to do this with the MID function, which is a text function. I just didn’t know if I had to convert the starting number to text before extracting the digits.
So I whipped up the attached worksheet and popped in the formulas. The answer: no, you don’t need to convert the number to text first.
The MID function has 3 arguments:
- text is the text you want to extract characters from. For this example, it’s the four-digit number.
- start_num is the number of the first character in the string you want to extract. For this example, it’s the digit number (1 though 4).
- num_chars is the number of characters you want to extract. For this example, it’s 1.
You can examine the formulas in the spreadsheet for yourself to learn more. Download it here.
Hope this helps, Jamie!
On July 22, 2008 at 5:46 pm, 
On July 18, 2008 at 6:26 am, 
On July 18, 2008 at 6:12 am, 
On July 17, 2008 at 5:37 pm, 
On July 17, 2008 at 1:53 pm, 
On July 16, 2008 at 9:40 pm, 
Loading ...
1 response so far ↓
1 jamie // Jul 11, 2007 at 11:07 am
thanks soo much worked like a charm will reccomend you to everyone who needs help thanks again
jamie
Leave a Comment