表示用セル | | | | 入力用セル |
=TRIM(MID(RIGHT(REPT(CHAR(32),12)&E2,12),1,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E2,12),4,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E2,12),7,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E2,12),10,3)) | 0 |
=TRIM(MID(RIGHT(REPT(CHAR(32),12)&E3,12),1,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E3,12),4,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E3,12),7,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E3,12),10,3)) | 1 |
=TRIM(MID(RIGHT(REPT(CHAR(32),12)&E4,12),1,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E4,12),4,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E4,12),7,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E4,12),10,3)) | 12 |
=TRIM(MID(RIGHT(REPT(CHAR(32),12)&E5,12),1,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E5,12),4,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E5,12),7,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E5,12),10,3)) | 123 |
=TRIM(MID(RIGHT(REPT(CHAR(32),12)&E6,12),1,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E6,12),4,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E6,12),7,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E6,12),10,3)) | 1234 |
=TRIM(MID(RIGHT(REPT(CHAR(32),12)&E7,12),1,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E7,12),4,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E7,12),7,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E7,12),10,3)) | 12345 |
=TRIM(MID(RIGHT(REPT(CHAR(32),12)&E8,12),1,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E8,12),4,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E8,12),7,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E8,12),10,3)) | 123456 |
=TRIM(MID(RIGHT(REPT(CHAR(32),12)&E9,12),1,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E9,12),4,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E9,12),7,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E9,12),10,3)) | 1234567 |
=TRIM(MID(RIGHT(REPT(CHAR(32),12)&E10,12),1,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E10,12),4,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E10,12),7,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E10,12),10,3)) | 12345678 |
=TRIM(MID(RIGHT(REPT(CHAR(32),12)&E11,12),1,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E11,12),4,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E11,12),7,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E11,12),10,3)) | 123456789 |
=TRIM(MID(RIGHT(REPT(CHAR(32),12)&E12,12),1,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E12,12),4,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E12,12),7,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E12,12),10,3)) | 1234567890 |
=TRIM(MID(RIGHT(REPT(CHAR(32),12)&E13,12),1,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E13,12),4,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E13,12),7,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E13,12),10,3)) | 12345678901 |
=TRIM(MID(RIGHT(REPT(CHAR(32),12)&E14,12),1,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E14,12),4,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E14,12),7,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),12)&E14,12),10,3)) | 123456789000 |
貼り付けたら、
表示用セル | | | 入力用セル |
=TRIM(MID(RIGHT(REPT(CHAR(32),9)&D2,9),1,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),9)&D2,9),4,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),9)&D2,9),7,3)) | 0 |
=TRIM(MID(RIGHT(REPT(CHAR(32),9)&D3,9),1,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),9)&D3,9),4,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),9)&D3,9),7,3)) | 1 |
=TRIM(MID(RIGHT(REPT(CHAR(32),9)&D4,9),1,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),9)&D4,9),4,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),9)&D4,9),7,3)) | 12 |
=TRIM(MID(RIGHT(REPT(CHAR(32),9)&D5,9),1,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),9)&D5,9),4,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),9)&D5,9),7,3)) | 123 |
=TRIM(MID(RIGHT(REPT(CHAR(32),9)&D6,9),1,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),9)&D6,9),4,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),9)&D6,9),7,3)) | 1234 |
=TRIM(MID(RIGHT(REPT(CHAR(32),9)&D7,9),1,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),9)&D7,9),4,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),9)&D7,9),7,3)) | 12345 |
=TRIM(MID(RIGHT(REPT(CHAR(32),9)&D8,9),1,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),9)&D8,9),4,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),9)&D8,9),7,3)) | 123456 |
=TRIM(MID(RIGHT(REPT(CHAR(32),9)&D9,9),1,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),9)&D9,9),4,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),9)&D9,9),7,3)) | 1234567 |
=TRIM(MID(RIGHT(REPT(CHAR(32),9)&D10,9),1,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),9)&D10,9),4,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),9)&D10,9),7,3)) | 12345678 |
=TRIM(MID(RIGHT(REPT(CHAR(32),9)&D11,9),1,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),9)&D11,9),4,3)) | =TRIM(MID(RIGHT(REPT(CHAR(32),9)&D11,9),7,3)) | 123456789 |