Welcome Guest
You last visited May 28, 2017, 4:41 am
All times shown are
Eastern Time (GMT-5:00)

Gap Theory

Topic closed. 15 replies. Last post 10 years ago by budward.

 Page 2 of 2

United States
Member #33295
February 19, 2006
699 Posts
Offline
 Posted: July 29, 2007, 7:17 pm - IP Logged

Welcome to LP cosmocos,

You will probably get an answer to your Excel question if you post it in the Mathematics forum.

Welcome to LP cosmocos,

I agree with LottoChica. Try posting anymore questions in the Math Forum.

Here is what I would do.

Put these formulas in to separate the # 5513 into separate cells and then drag formulas down entire list of numbers.

A      B             C                             D                               E                          F

 5513 =INT(A1/1000) =INT((A1-(C1*1000))/100) =INT((A1-((C1*1000)+( D1*100)))/10) =INT((A1-((C1*1000)+(D1*100)+(E1*10)/1)))

This will give you the following

 A B C D E F 5513 5 5 1     3

Then use these formulas IN cells H1,I1,J1,K1 AND drag down entire list of numbers

H                  I                    J                    K

 =SMALL(C1:F1,1) =SMALL(C1:F1,2) =SMALL(C1:F1,3) =SMALL(C1:F1,4)

This will give you the following,

 H I J K 1 3 5 5

Then if you want all 4 #'s back together in 1 cell, use this formula in Cell M1 and drag down list of numbers.

 =CONCATENATE(H1,I1,J1,K1)This will give you
 M 1355You can then highlight Columns C,D,E,F,H,I,J,K and drag them off to the right side of the sheet out of the way and drag Column M over to Column C or  move or leave the Columns as you see fit to do.Hope this is helpful...Bud                              Sorry, the Column letters don't quite line up in the post.

Isabel, you are going to feel very silly when this turns out to be make-believe.

 Page 2 of 2