|
|
此文章由 steveking 原创或转贴，不代表本站立场和观点，版权归 oursteps.com.au 和作者 steveking 所有！转贴必须注明作者、出处和本声明，并保持内容完整
Ok seems simple enough but can't seem to find a solution. I have some cols of data which I'd like to copy but I want the values enclosed as follows.
Sheet2!S10=9999
A1=Sheet2!S
B1=10
C1=A1&B1
Or
C1=Sheet2!S10
The columns B1 of data will be updated continuously so I need a formula.
Unfortunately, C1=A1&B1 doesn’t work which only presents “Sheet2!S10”, not “9999”
Any ideas on a formula for this?
Thanks
[ 本帖最后由 steveking 于 2010-9-1 11:37 编辑 ] |
|
简单的小点心--心太软 (2005-1-10) chris2002 
发表于 2010-9-1 11:33
