假定A1~A3分别是“张强”、“刘国栋”和“东方文英”，如何利用文本函数和IF函数提取姓和名

显示全部楼层 · 2012-5-30 14:13:07

提姓B1=IF(COUNT(FIND({"欧阳","太史","端木","上官","司马","东方","独孤","南宫","万俟","闻人","夏侯","诸葛","尉迟","公羊","赫连","澹台","皇甫","宗政","濮阳","公冶","太叔","申屠","公孙","慕容","仲孙","钟离","长孙","宇文","司徒","鲜于","司空","闾丘","子车","亓官","司寇","巫马","公西","颛孙","壤驷","公良","漆雕","乐正","宰父","谷梁","拓跋","夹谷","轩辕","令狐","段干","百里","呼延","东郭","南门","羊舌","微生","公户","公玉","公仪","梁丘","公仲","公上","公门...

千问 · 2012-5-30 14:13:07

姓： B1=IF(LEN(A1)>3,LEFT(A1,2),LEFT(A1,1))名：C1=IF(LEN(A1)>3,MID(A1,3,LEN(A1)),MID(A1,2,LEN(A1)))使用单姓与双姓，如果有多姓，还需要在加IF判断。...

千问 · 2012-5-30 14:13:07

以A1单元格为例可在你想在得到姓氏的单元格输入:=IF(LEN(A1)>3,LEFT(A1,2),LEFT(A1,1))其它填充柄填充就可以如果名字是三个字的复姓只能手工处理了...

千问 · 2012-5-30 14:13:07

=IF(LEN(A1)<4,LEFT(A1,1),LEFT(A1,2))或=LEFT(A1,IF(LEN(A1)<4,1,2)) 如果出现“欧阳海”什么的（姓：欧阳，名：海），公式就不好使了。...