いまさら聞けないExcelの使い方講座 【Excel】基本操作にかかる時間を短縮して脱・初心者！絶対役立つエクセルのファンクションキー活用テク5選 ...

For example, suppose you imported a CSV file into Excel, with the first names in column A and surnames in column B. With CONCAT you can join them and arrange them anyway you want.

To merge or combine the first and last names in Excel you can make use of the CONCAT Ampersand, Flash Fill or TEXTJOIN functions or formulas.

Adding a text to a cell in Excel using Formula requires use of ampersand operator, CONCAT function, or the LEFT, RIGHT, and LEN functions.