412,397 views
32 votes
32 votes
What formula would you enter in c3 that combines a3 and b3 to get a result like in c2?

User Bogtan
by
2.8k points

1 Answer

14 votes
14 votes
To combine the contents of cells A3 and B3 in a manner similar to the result in cell C2, you can use the CONCATENATE function in the following formula:

=CONCATENATE(A3, B3)
This formula will combine the contents of cells A3 and B3 into a single text string. For example, if cell A3 contains the text "Hello" and cell B3 contains the text "world", the formula will return the result "Helloworld" in cell C3.

Alternatively, you can use the concatenation operator (&) to combine the contents of cells A3 and B3 in the following formula:

=A3 & B3
This formula will have the same result as the CONCATENATE function, but it uses a more concise syntax. The concatenation operator automatically adds a space between the contents of cells A3 and B3, so the result in cell C3 would be "Hello world" instead of "Helloworld".
User Steve Newton
by
2.9k points