Excel 高手請進!! - (15分)

2006-10-17 11:45 pm
有一個report,唔同既material assign左俾唔同數目既factory,
Report 如下:
Material A
Factory# of material A

Material B
Factory # of material B
Factory # of material B

Material C
Factory # of material C
Factory # of material C
Factory # of material C

所以我希望在excel令到個report變成如下:
Material AFactory # of material A
Material BFactory # of material B
Material BFactory # of material B
Material CFactory # of material C
Material CFactory # of material C
Material CFactory # of material C
更新1:

Old: A 1 Material A 2 Factory# of material A 3 4 Material B 5 Factory # of material B 6 Factory # of material B New: A B 1 Material A Factory # of material A 2 Material B Factory # of material B 3 Material B Factory # of material B

回答 (2)

2006-10-17 11:54 pm
✔ 最佳答案
你的意思是不是將兩個cell的內容放在一個cell裡面? 如果是:

假設 Material A 在cell A1, Factory # of material A 在cell B1, 你在cell C1 請輸入:

=A1&B1

如果你想中間隔一格:

=A1&" "&B1
參考: 自己
2006-10-17 11:59 pm
都唔明你想點, 係咪sort d files ar? copy and paste lor


收錄日期: 2021-04-18 20:03:11
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20061017000051KK01850

檢視 Wayback Machine 備份