如何用VBA将表中A列的字符位置调换为B列的模样

china047 · 发表于 2022-8-16 10:30

请各位老师帮忙用VBA将表中A列的面料描述成份位置调换成B列的样子(中文名称表作为分割字符参考,不知是否有帮助),先谢过各位老师!

字符串位置调换.rar (4.53 KB, 下载次数: 12)

hcm19522 · 发表于 2022-8-16 11:36

C2:F8=IF(COLUMN(A1)>(LEN($A2)-LEN(SUBSTITUTE($A2," ",))+1)*2,"",IF(COLUMN(A1)=1,LEFT(A2,FIND(":",A2)),"")&TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A2,"%"," "),":"," ")," ",REPT(" ",99)),CHOOSE(COLUMN(A1),3,2,5,4)*99-98,99))&IF(MOD(COLUMN(A1),2),"","% ")&D2)

		自动登录	找回密码
密码			免费注册

[求助] 如何用VBA将表中A列的字符位置调换为B列的模样

评分