第1个回答 2015-10-09
在Sheet2的B2单元格输入以下公式,然后向右向下填充公式
=VLOOKUP($A2,Sheet1!$A:$C,COLUMN(B1),0)
第2个回答 2015-10-09
这个是求年龄的=MID(Sheet1!A1,FIND("@",SUBSTITUTE(Sheet1!A1,"//","@",2))+2,FIND("@",SUBSTITUTE(Sheet1!A1,"//","@",3))-FIND("@",SUBSTITUTE(Sheet1!A1,"//","@",2))-2)
这个是求性别的=MID(Sheet1!A1,FIND("@",SUBSTITUTE(Sheet1!A1,"//","@",1))+2,FIND("@",SUBSTITUTE(Sheet1!A1,"//","@",2))-FIND("@",SUBSTITUTE(Sheet1!A1,"//","@",1))-2)