EXCEL中如何合并单元格内重复的字符,因有大批量处理,需要利用公式。要求将A列内容调整成B列内容
如果题主用的是WPS,可以用下面的数组公式:
B2数组公式:=TEXTJOIN(",",1,TRIM(MID(SUBSTITUTE(A2,",",REPT(" ",99)),ROW($1:$99)*99-98,99)))
重复的逗号可以解决,公式:
=SUBSTITUTE(SUBSTITUTE(A1,",,",","),",,",",")
效果: