Separate P3 & P4 Combinations Into Individual Digits In Excel

Reply #5

ithastobesaid — Fri, 01 May 2015 14:12:08 GMT

This may be simpler for you:

Cell A2 = 123

Cell B2 = =int(left(text(A2, 000 ),1))

Cell C2 = =int(mid(text(A2, 000 ),2,1))

Cell D2 = =int(right(text(A2, 000 ),1

Reply #4

Technut — Fri, 01 May 2015 03:12:21 GMT

There is another way to split the data apart but it also depends on how you have the data to begin with. What i am reffering to is CSV or Comma Seperated Value file format. The data i have for use in one of the programs i use is in this format. example (MM,DD,YYYYY,B1,B2,B3) if i load this into excel correctly it will split the data into separate cells. I have used this method before for breakdown in the past for splitting purposes.

Reply #3

Raven62 — Wed, 08 Apr 2015 17:32:30 GMT

Couldn't agree more! However, when faced with a Large Quantity of Three or Four Digit Combinations it's easier to let Excel separate them into Individual Digits.

Reply #2

GASMETERGUY — Mon, 06 Apr 2015 19:23:17 GMT

One should always put individual numbers into a separate cell. This way one can manipulate the data with Visual Basic. It makes for finding patterns that much easier.

Reply #1

Raven62 — Mon, 06 Apr 2015 18:08:47 GMT

Pick 4:

Cell A2=1234

Cell B2= =(MOD($A2,10000)-MOD($A2,1000))/1000

Cell C2= =(MOD($A2,1000)-MOD($A2,100))/100

Cell D2= =(MOD($A2,100)-MOD($A2,10))/10

Cell E2= =MOD($A2,10

Separate P3 & P4 Combinations Into Individual Digits In Excel

Raven62 — Mon, 06 Apr 2015 18:03:14 GMT

Pick 3:

Cell A2=123

Cell B2= =(MOD($A2,1000)-MOD($A2,100))/100

Cell C2= =(MOD($A2,100)-MOD($A2,10))/10

Cell D2= =MOD($A2,10