hello master.
How anyone can let me know the excel formula : how to mix the data from the column A and B into column C
an ex sample : C has the data 123456 which those data from A 123 AND B 456.
Thank you very much
excel formula
2008-01-09 11:15 pm
回答 (3)
2008-01-09 11:44 pm
✔ 最佳答案
Assume cell A1 is 123 cell B1 is 456formula will be
=A1&B1
you will get 123456
參考: me
2008-01-09 11:53 pm
In tool bar, choose "fx" icon, in category -- Text, in Function name -- Concatenate, OK.
in Text 1 select the first number, Text 2 select 2nd number, then and so on, then click OK. That's it.
Hope can help you.
in Text 1 select the first number, Text 2 select 2nd number, then and so on, then click OK. That's it.
Hope can help you.
2008-01-09 11:30 pm
there is a text function called "Concatenate"
收錄日期: 2021-04-25 19:28:16
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20080109000051KK01710