[求助]如何提取A列文本的拼音首字母（如张三-->ZS）？

blue0o0

比如有三列，A列为文本，B列为数字，C列＝A列文本拼音首字母＋（B列数字）＋固定文本“_R1841”，如何才能得到C列结果？详情请查看附件。谢谢！

xKUdiUFX.rar (3.61 KB, 下载次数: 64)

2006-7-3 15:32 上传

点击文件名下载附件
[求助]如何提取A列文本的拼音首字母（如张三-->ZS）？

[此贴子已经被作者于2006-7-3 15:33:01编辑过]

yylucke

请看附件 A8UZ9H0X.rar (1.52 KB, 下载次数: 176)

2006-7-3 15:09 上传

点击文件名下载附件
[求助]如何提取A列文本的拼音首字母？

gouweicao78

=LOOKUP(A2,{"","";"吖","A";"八","B";"嚓","C";"咑","D";"鵽","E";"发","F";"猤","G";"铪","H";"夻","J";"咔","K";"垃","L";"嘸","M";"旀","N";"噢","O";"妑","P";"七","Q";"囕","R";"仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"})&B2&"_R1841"

Lookup就可以了。

qx1999

三楼的朋友能否解释一下：

"","";"吖","A";"八","B";"嚓","C";"咑","D";"鵽","E";"发","F";"猤","G";"铪","H";"夻","J";"咔","K";"垃","L";"嘸","M";"旀","N";"噢","O";"妑","P";"七","Q";"囕","R";"仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"

[此贴子已经被作者于2006-7-3 15:15:54编辑过]

blue0o0

哇，太棒啦！谢谢各位！！！！

blue0o0

但是我要的是A列文本所有文字的拼音首字母，如“福州所”->“FZS”，请继续帮忙！！！

gouweicao78

用同样方法：

比如Lookup(Mid(A1,1,1),{……})&Lookup(Mid(A1,2,1),{……})&……

blue0o0

还是不明白，我比较菜。

[此贴子已经被作者于2006-7-3 15:34:31编辑过]

浔人

可以按三楼gouweicao斑竹的作个对应表，用LOOKUP就可以了，那数组实际就是个对应表

[此贴子已经被作者于2006-7-3 15:37:31编辑过]

gouweicao78

认真搜索一下就有了，自定义函数

http://club.excelhome.net/viewthread.php?tid=66766