Which of the following is the correct formula to use in order to - ProProfs Discuss
Topics-
Products +
     

Which of the following is the correct formula to use in order to combine the last name and first name in this example so that the end result is what you see in Cell D2?



A. =TRANSPOSE(B2, C2)
B. =COMBINE(B2,", ",C2)
C. =CONCATENATE(B2,", ",C2)
D. =TEXT (B2:C2, PROPER)
E. I don t know the answer to this question.

This question is part of Excel 2010 Skills Assessment
Asked by Carlson, Last updated: Dec 05, 2017

+ AnswerRequest Answer
...

1 Answer

John Smith

John Smith

Answered on Oct 25, 2016

=concatenate(b2,", ",c2)
 Reply

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.