172k views
3 votes
Joshua needs to join the text in two cells together. which of the following would perform this function?

a. ="good" "morning"
b. ="good"&"morning"
c. =good "&" morning
d. ="good"&&"morning"

User Vyga
by
8.6k points

2 Answers

4 votes

Answer:a good morning

Step-by-step explanation:

User Ted Lowery
by
8.2k points
1 vote
B. ="Good"&"Morning" would work. All you have to do is put quotation marks and an & between each word you wish to join. If you were joining two specific cells you'd typically use =A1&B1 (with the A1 and B1 being your cell names) though for no space and =A1&" "&B1 to include a space.

You could also use the cocatanate method to join specific cells together like so: =CONCATENATE(A1, B1) or =CONCATENATE(A1, " ", B1) to include a space.


User Bas Wijnen
by
7.5k points