哪位EXCEL高手能解决这问题解决，牛

来源：百度知道 编辑：UC知道 时间：2024/06/07 14:43:08
A 列
1275071419
1275071419
1275071419
1275071419

C列

[1278071417]
[1278071418]+[1278071420]
[1278071417]+[1278071418]
[1278071419]+[1278071420]

D列
{ISNULL ([GBP_HUA_TBL_1275071419_6000.COUNTER_1278071417],0)}

{ISNULL([GBP_HUA_TBL_1275071419_6000.COUNTER_1278071418],0)}+{ISNULL([GBP_HUA_TBL_1275071419_6000.COUNTER_1278071420],0)}

{ISNULL([GBP_HUA_TBL_1275071419_6000.COUNTER_1278071417],0)}+{ISNULL([GBP_HUA_TBL_1275071419_6000.COUNTER_1278071418],0)}

{ISNULL([GBP_HUA_TBL_1275071419_6000.COUNTER_1278071419],0)}+{ISNULL([GBP_HUA_TBL_1275071419_6000.COUNTER_1278071420],0)}

怎么样由A列，B列，得到D列。

假定从第10行开始，D列10、11、12、13函数如下。后三行是一致的函数，用填充柄就可以填充。若要将4行合并，可以用if加search函数判断一下，B列数据有+号，就用后三行的公式，没有+号，就用第一行的公式。

="{ISNULL ([GBP_HUA_TBL_"&A10&"_6000.COUNTER_"&LEFT(RIGHT(B10,11),10)&"],0)}"
="{ISNULL ([GBP_HUA_TBL_"&A11&"_6000.COUNTER_"&RIGHT(LEFT(B11,11),10)&"],0)}"&"+"&"{ISNULL ([GBP_HUA_TBL_"&A11&"_6000.COUNTER_"&LEFT(RIGHT(B11,11),10)&"],0)}"
="{ISNULL ([GBP_HUA_TBL_"&A12&"_6000.COUNTER_"&RIGHT(LEFT(B12,11),10)&"],0)}"&"+"&"{ISNULL ([GBP_HUA_TBL_"&A12&"_6000.COUNTER_"&LEFT(RIGHT(B12,11),10)&"],0)}"
="{ISNULL ([GBP_HUA_TBL_"&A13&"_6000.COUNTER_"&RIGHT(LEFT(B13,11),10)&"],0)}"&"+"&"{ISNULL ([GBP_HUA_TBL_"&A13&"_6000.COUNTER_"&LEFT(RIGHT(B13,11),10)&"],0)}"

替换 或者 substitute函数。

D1
=SUBSTITUTE(SUBSTITUTE(C