日常工作頻繁需取漢字/詞語首字母（音序查字、藥品/歌曲檢索系統）。WPS表格內建排序已隱含拼音內碼邏輯，利用`CODE`查內碼、`LOOKUP`對照音序區間，三秒搞定首字母提取。

核心公式（取儲存格A2第一字首字母）

=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"})

原理：`CODE`取首字內碼 → `LOOKUP`在23個音序起始內碼區間中定位 → 返回對應字母。

進階變體

取第二字首字母

=LOOKUP(CODE(MID(A2,2,1)),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"})

`MID(A2,2,1)`提取第二字，其餘邏輯同前。第三字同理改`MID(A2,3,1)`。

取前兩字/三字首字母組合

用`&`串聯多個上述公式：

=LOOKUP(CODE(A2),... ) & LOOKUP(CODE(MID(A2,2,1)),... ) & LOOKUP(CODE(MID(A2,3,1)),... )

即得如「ZHS」三字母代碼。

應用場景

• 學生音序查字練習模板
• 醫院藥品/醫院KTV歌曲檢索索引建立
• 人員姓名代碼批量生成（配合前文姓名代碼教學）

模板預覽

掌握此公式，漢字轉拼音首字母不再需外掛工具，表格內原生解決！