Another Excel Question...

Reply #6

winsumloosesum — Sat, 31 Jul 2010 00:38:06 GMT

7412 (In Cell J3)

=INT(J3/1000) ' Formula in cell K3

=INT((J3-(K3*1000))/100) ' Formula in cell L3

=INT((J3-((K3*1000)+(L3*100)))/10) ' Formula in cell M3

=INT((J3-((K3*1000)+(L3*100)+(M3*10)))) ' Formula in cell N3

Reply #5

Rakster — Fri, 30 Jul 2010 05:21:35 GMT

Thanks guys...

Reply #4

hotshot4 — Wed, 28 Jul 2010 12:28:59 GMT

You will not have to use a formula if you use the Data to Column, and you can do a whole column of numbers. Work with it

and see how easy it is.

Reply #3

Raven62 — Wed, 28 Jul 2010 03:58:43 GMT

Lottery Post Forums Search is Your Friend:

https://www.lotterypost.com/thread/172280/1000196

Reply #2

phileight — Wed, 28 Jul 2010 01:37:51 GMT

I assume you are looking for a formula

several ways to do this. my favorite is =mid(j3,1,1) for the first # then =mid(j3,2,1) etc.

j3 is obviously cell reference. next digit defines the position you want to start, then 3rd # tells it how many #'s to select. by using 1 i get 1 number

Reply #1

hotshot4 — Tue, 27 Jul 2010 23:25:05 GMT

Hi-Lite the cell the numbers are in, click on Data, then Text to Columns, click the Fixed width , then next, click on to creat a breaking line click

at the desired position, (place a line between each didgit), then click finsh.

Hope this works for you

Another Excel Question...

Rakster — Tue, 27 Jul 2010 21:45:34 GMT

If I have the number 7412 in cell J3

How do I formulate it so I can get the 7 in one cell, the 4 in another cell the 2 in another cell and the 1 in another cell?

These formulas get me the first 3 digits into seperate columns but how do I get the 4th digit...anyone know the formula for this one?

Thanks

=IF(ISBLANK(J3), ,INT(J3/100))

=IF(ISBLANK(J3), ,INT((J3-(K3*100))/10))

=IF(ISBLANK(J3), ,INT((J3-((K3*100)+L3*10