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

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: Jan 01, 2020

+ Answer
Request

1 Answer

John Smith

John Smith

Answered Oct 25, 2016

=concatenate(b2,",...Read More
 

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.