Ask Question
4 June, 14:54

What formula would you enter in C4 that combines A4 and B4 to

get a result like in C2?

=A4&&B4

=A4&" "&B4

="A4"&""&"34"

=A4&""&B4

+1
Answers (1)
  1. 4 June, 15:07
    0
    Since the question is missing the contents of A4, B4, and C2, see below the explanations for two possible cases.

    Explanation:

    The command that is used in excel worksheets to combine the content of two (or more) cells into other cell is &.

    The content on the resulting cell is will be a text, independent on whether the starting cells had text or numbers.

    If you do not want to add any character or blank space in between the content of the starging cells, just use &.

    The procedure is:

    Select the cell where you want to put the combined dа ta: C2 in your case. Type = or + and select the first cell you want to combine: A4 in your case. Type & Select the other cell that you want to combine: B4 in your case Press enter. Done.

    Thus, if you do not want to add any character, the answer would be:

    =A4&B4. That is not a choice. But notice that = A4&""&B4 yields the same result.

    If you want to add some characters or blank space in between the content of the starging cells, use &" whatever you want to add in between"&

    The procedure is:

    Select the cell where you want to put the combined dа ta: C2 in your case. Type = or + and select the first cell you want to combine: A4 in your case. Type & Type " Type whatever you want to add in betwen Type " Type & Select the other cell that you want to combine: B4 in your case Press enter. Done.

    If you you want to add a blank space the answer would be:

    =A4&" "&B4.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “What formula would you enter in C4 that combines A4 and B4 to get a result like in C2? =A4&&B4 =A4&" "&B4 ="A4"&""&"34" =A4&""&B4 ...” in 📘 Business if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers