點樣係exal入面用公式將a1234ASBW分別將佢地拆散啊?
拆散成a1234同埋ASBW
唔該曬!
exal問題~幫幫手~~
2008-03-17 2:21 am
回答 (2)
2008-03-17 4:31 am
AI 輸入=A1234ABSW
B1 輸入=REPLACE(A1,5,4,0)
C1 輸入=REPLACE(A1,1,5,)
B1 輸入=REPLACE(A1,5,4,0)
C1 輸入=REPLACE(A1,1,5,)
2008-03-17 2:23 am
I think you mean excel
if A1=a1234ASBW
in B1, for a1234 =left(A1,5)
In C1, for ASBW=right(A1,4)
if A1=a1234ASBW
in B1, for a1234 =left(A1,5)
In C1, for ASBW=right(A1,4)
參考: own knowledge
收錄日期: 2021-04-14 18:58:06
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20080316000051KK02438