How to link multiple columns within the same row in Excel?

When curating website sections, I happened to need this specific combination, so I did some research on it.

Specific Method

In Excel, you can use the CONCATENATE function or the & operator to combine multiple columns within the same row.

Method 1: Use the CONCATENATE function

1. If you want to concatenate the values in columns A1, B1, and C1, you can enter the following formula in cell D1: =CONCATENATE(A1, B1, C1)
2. Press the Enter key; Cell D1 will display the result obtained by concatenating the contents of Cells A1, B1, and C1.

Method 2: Use the & operator

1. As in Method 1, if you want to concatenate the three columns A1, B1, and C1, you can enter the following formula in cell D1: =A1 & B1 & C1
2. Press the Enter key; Cell D1 will display the result obtained by concatenating the contents of Cells A1, B1, and C1.

Regardless of the method you use, you can copy and paste this formula wherever needed to link multiple columns across other rows.

The formula I am using

=CONCATENATE(C1, "|【", A1, "】栏目为您提供关于【", A1, "】分享，", B1, "如果您觉得", C1,"栏目不错，请多多支持！我们将持续分享更好的", A1, "。")