1Զո
AΪѡAУ༭λλֵ=A2Ctrl+EnterλĿݼCtrl+G

2vlookup

3س
ͨڲҿڣͨctrl + f룺סaltţȻּͨ10֣ſּٷſalt
ʽ滻س =SUBSTITUTE(A1,CHAR(10)," ")