More than 5 years have passed since last update.

ExcelでA,B,C...AA,AB,AC みたいなのを作る

Excel
spreadsheet

Last updated at 2019-11-19Posted at 2019-11-19

需要があるか不明ですが、掲題について

一行目の式：=UNICHAR(64+ COLUMN())
二行目の式：=MOD(COLUMN()-1,26)
三行目の式：=ROUNDDOWN((COLUMN()-1)/26,0)
四行目の式：=UNICHAR(65+MOD((COLUMN()-1)-1,26))
とんで
六行目の式：=IF(ROUNDDOWN((COLUMN()-1)/26,0)=0,"",UNICHAR(64+ROUNDDOWN((COLUMN()-1)/26,0))) & UNICHAR(65+MOD(COLUMN()-1,26))

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up