需求：學生音序查字、醫院藥品查詢、KTV 點歌系統，皆需漢字首字母。ET/Excel 能按音序排序，底層已建立編碼與拼音映射。利用 CODE 取字元內碼，LOOKUP 對照各聲母起始碼位，即得首字母。

核心公式（取第一字聲母）

=LOOKUP(CODE(A2),45217+{0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{"A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"})

A2 為漢字儲存格。CODE 取首字元內碼，LOOKUP 依 23 個聲母起始碼位區間匹配。

取第 2、3 字聲母

將 A2 替換為 MID(A2,2,1)、MID(A2,3,1) 即可（公式結構同）。

合併前 2/3 字聲母

用 & 串聯多組公式。前三字聲母完整公式見原文末段。

附：可下載現成模板（獲取漢字音序的模板.et）。