Question

which formula will you use to concentrate or join two strings please answer​

Answer 1

Answer:

CONCATENATE function

The CONCATENATE function in Excel is designed to join different pieces of text together or combine values from several cells into one cell. The syntax of Excel CONCATENATE is as follows: CONCATENATE(text1, [text2], …) Where text is a text string, cell reference or formula-driven value.

Answer 2

Explanation:

Select a cell where you want to enter the formula. Type =CONCATENATE( in that cell or in the formula bar. Press and hold Ctrl and click on each cell you want to concatenate. Release the Ctrl button, type the closing parenthesis in the formula bar and press Enter.

HOPE IT HELPS. (^^)