excel如何提取部分?jǐn)?shù)據(jù)？

如果比用的是Office 2013以上的版本? ??

假如數(shù)據(jù)從A1開始的? ? ?你先手動復(fù)制一個(gè)? 例如（廣東深圳，羅湖區(qū)）到B1

然后才B2單元格按CTRL+E? 會自動填充

如果是低于這個(gè)版本? 或者用的WPS? 那只能用函數(shù)來完成

B1=LEFT(A1,FIND("區(qū)",A1))

下拉即可

數(shù)據(jù)不規(guī)范，會給后續(xù)帶來很多不必要的麻煩，如圖，B1單元格輸入公式=TRIM(IF(COLUMN()=2,MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A1,"："," "),"，"," ")," ",REPT(" ",20)),1,40),MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A1,"："," "),"，"," ")," ",REPT(" ",20)),COLUMN(B1)*20-19,20)))

右拉公式到E列，再下拉公式。