EG
A1=A, B1=B, C1=C
我用CONCATENATE(A1,B1,C1)=ABC,
但如果我想字與字之間有空間,即是A B C,怎麼辦?
有冇高手???
excel formula 一問
2009-06-19 5:25 am
回答 (3)
2009-06-19 9:45 pm
✔ 最佳答案
http://i199.photobucket.com/albums/aa194/taioiying/ScreenHunter_16Jun191342.gif入上面條LINK 看看其他做法^_^
2009-06-19 5:48 am
(1) =CONCATENATE(A1," ",B1," ",C1)
(2) =A1&" "&B1&" "&C1
(2) =A1&" "&B1&" "&C1
收錄日期: 2021-04-27 13:13:08
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20090618000051KK02063