我正在尝试批量复制 A 列中单元格的内容,并将其插入 B 列中文本的“><”内。结果应该看起来像 C 列中的输出。这是一个例子:
我将非常感激您的回复!
Column A
This is
a test
I hope it works
Alarm Triggered
Column B
<string name="app_name"></string>
<string name="alarme_service_ativado"></string>
<string name="alarme_service_desativado"></string>
<string name="alarme_service_disparado"></string>
Column C
<string name="app_name">This is </string>
<string name="alarme_service_ativado">a test </string>
<string name="alarme_service_desativado">I hope it works</string>
<string name="alarme_service_disparado">Alarm Triggered</string>
答案1
那么 C 列中的公式应如下所示:
=MID(B1,1,SEARCH("><",B1,1))&A1&MID(B1,SEARCH("><",B1,1)+1,LEN(B1)-SEARCH("><",B1,1))
结果: