14,970
edits
Concatenate strings: Difference between revisions
Jump to navigation
Jump to search
m
→Excel
(Created page with "String Concatenation == Excel == * Using {{kbd | key=<nowiki>&</nowiki>}} symbol to concatenate different cells such as {{kbd | key=<nowiki>A1&B1</nowiki>}}. * Using the [ht...") |
m (→Excel) |
||
| Line 4: | Line 4: | ||
* Using {{kbd | key=<nowiki>&</nowiki>}} symbol to concatenate different cells such as {{kbd | key=<nowiki>A1&B1</nowiki>}}. | * Using {{kbd | key=<nowiki>&</nowiki>}} symbol to concatenate different cells such as {{kbd | key=<nowiki>A1&B1</nowiki>}}. | ||
* Using the [https://support.office.com/zh-hk/article/concat-%E5%87%BD%E6%95%B8-9b1a9a3f-94ff-41af-9736-694cbd6b4ca2 CONCAT] or [https://support.office.com/zh-hk/article/concatenate-%E5%87%BD%E6%95%B8-8f8ae884-2ca8-4f7a-b093-75d702bea31d CONCATENATE] function. | * Using the [https://support.office.com/zh-hk/article/concat-%E5%87%BD%E6%95%B8-9b1a9a3f-94ff-41af-9736-694cbd6b4ca2 CONCAT] or [https://support.office.com/zh-hk/article/concatenate-%E5%87%BD%E6%95%B8-8f8ae884-2ca8-4f7a-b093-75d702bea31d CONCATENATE] function. | ||
* Using the [https://support.office.com/zh-hk/article/textjoin-%E5%87%BD%E6%95%B8-357b449a-ec91-49d0-80c3-0e8fc845691c TEXTJOIN] function. {{Gd}} Easy to defined the separator of different cells. | * Using the [https://support.office.com/zh-hk/article/textjoin-%E5%87%BD%E6%95%B8-357b449a-ec91-49d0-80c3-0e8fc845691c TEXTJOIN] function. {{Gd}} Easy to defined the separator of different cells <ref>[https://stackoverflow.com/questions/41125877/concatenate-a-range-of-cells-with-a-comma google sheets - Concatenate a range of cells with a comma - Stack Overflow]</ref>. | ||
== MySQL == | == MySQL == | ||