取最後面資料 (11074)

C2=TRIM(RIGHT(SUBSTITUTE(A2&"┇"&A2,"┇",REPT(" ",99)),99))

另解=IF(ISNUMBER(FIND("┇",A2)),RIGHT(A2,LEN(A2)-FIND("┇",A2)),A2)

另解{=VLOOKUP("┇*",RIGHT("┇"&A2,ROW($1:$20)-{0,1}),2,)