months brokendown by 12 months

[Hank]

Hello, I need some help to breakdown a total months to months in a year, such
as

total 32 months will be broken down by 12month 12month and 8month
total 63 months will be broken down by 12month 12 month 12 month 12 month
12 month and 3 month.

Is there any function in excel can do that??

Thanks a lot
Hank

 

[Jacob Skaria]

Do you mean

A1 = 63
In B1
=REPT("12month ",INT(A1/12)) & "and " & MOD(A1,12) & "months"

If this post helps click Yes

 

[Hank]

I need numeric 12, 12, 12, 12 3

Thanks Jacob!

Hank

 

[Jacob Skaria]

'If you mean only the numerics in a cell then try the below

=REPT("12, ",INT(A1/12)) & MOD(A1,12)

'If you are looking to have the numerics in separate cells try the below
=IF(COLUMN(A1)<=INT($A1/12),12,IF(COLUMN(A1)=INT($A1/12)+1,MOD($A1,12),""))
and copy to the right as required

If this post helps click Yes