Question

this option is use to select more than two cells merged into one cell answer in one word​

Answer 1

Answer:

Combine data with the Ampersand symbol (&)

Type = and select the first cell you want to combine. ... Select the next cell you want to combine and press enter. An example formula might be =A2&" "&B2.