傳回文字

[AN21]

ŠpªG§Ú A1 ¿é€J 2009-10-1, ®æŠ¡¬°ŠÛ­q mmmm
A1 ·|Åã¥Ü OCTOBER
Šý§ÚŠb A2 ·QÅã¥Ü I Bron in October
="I Bron in "& TEXT(MONTH(a1),"mmmm")
·|Åã¥Ü I Bron in January
œÐ°ÝŠ³ÉN function ¥i¥H¶ÇŠ^žÓÀxŠs®æªº€åŠr
THX ALL

[天道無常]

="I Bron in "& TEXT(a1,"mmmm")

如果我 A1 輸入 2009-10-1, 格式為自訂 mmmm
A1 會顯示 OCTOBER
但我在 A2 想顯示 I Bron in October
="I Bron in "& TEXT(MONTH(a1),"mmmm")
會顯示 I Bron in January
請問有冇 function 可以傳回該儲存格的文字
THX ALL

[AN21]

thanks
­ìšÓ¥ÎŠh¥ª­Ó function