excel中怎么在包含数字的文本中提取文本答:一、插入辅助列 B1=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,0,""),1,""),2,""),3,""),4,""),5,""),6,""),7,"")C1=SUBSTITUTE(SUBSTITUTE(B1,8,""),9,"")两公式向下复制。二、把excel表中的数据复制到word中,之后用word进行以下...
excel中如何将一行中的数字和字母分离开答:设你要分离的内容在A2单元格,如在B2输出纯数字,则请用公式:=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,1,""),2,""),3,""),4,""),5,""),6,""),7,""),8,""),9,""),0,"")如在C2输出纯字母,则请用公式:=...
excel公式编写求助,大神请进,谢谢。答:C2公式:=CHAR(FIND(MID(B2,1,1),B2)+64)&CHAR(FIND(MID(B2,2,1),B2)+64)&CHAR(FIND(MID(B2,3,1),B2)+64)&CHAR(FIND(MID(B2,4,1),B2)+64)&CHAR(FIND(MID(B2,5,1),B2)+64)D2公式:=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(...
excel中如何将四个“|”替换成ABCD答:假设答案在A1单元格,形式为:|123|234|345|3456,则公式为:=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"|","A、",1),"|"," B、",1),"|"," C、",1),"|"," D、")如形式为:123|234|345|3456,则公式为:="A、"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"|"," B、",1...