数据換列表示 取資料 (11014)

C2=TRIM(LEFT(SUBSTITUTE(MID(SUBSTITUTE(B2,"规格：",REPT(" ",99)),99,99),CHAR(10),REPT(" ",99)),99))

另解=TRIM(LEFT(SUBSTITUTE(MID(B2,FIND("规格：",B2)+3,99),CHAR(10),REPT(" ",99)),99))