# 處理字串

{% tabs %}
{% tab title="💾 程式" %}
```excel-formula
=CONCATENATE("例如：",B3," ⨉ 20 = ", INT(B3*20), " 人")
```

結果：

```
例如：1.5 ⨉ 20 = 30 人
```
{% endtab %}

{% tab title="📘 手冊" %}
* [CONCATENATE](https://support.google.com/docs/answer/3094123?hl=en)
{% endtab %}

{% tab title="📗 參考" %}
* [How to Concatenate Data from Multiple Cells in Google Sheets](https://www.howtogeek.com/447559/how-to-concatenate-data-from-multiple-cells-in-google-sheets/)
{% endtab %}
{% endtabs %}
