私的メモ。

最後。エクセル。

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(I2,"F","05"),"C","04"),"B","03"),"A","02"),"S","01")
=IF(ISERROR(VALUE(L6)),"05",(IF(VALUE(L6)>29, "01", (IF(VALUE(L6)>25,"02",(IF(VALUE(L6)>21,"03",(IF(VALUE(L6)>9,"04","05")))))))))

apn

apn: sd.iijmobile.jp
user: mobile@iij
pw: iij
type: CHAP または PAP
apn: ppsim.jp
user: pp@sim
pw: jpn
type: CHAP または PAP
apn: linksmate.jp
user: user
pw: mate
type: CHAP