CONCATENATE This function allows you join two or more strings into one cell. Ins

Question

CONCATENATE This function allows you join two or more strings into one cell. Instructions Combine the text that you see in columns A and B below, into one cell in C. There should be a space between the first name and the last name when you join these texts. CONCATENATE George Washington <== Combine the text in column A and column B into this cell Mary Lincoln Richard Nixon CONCATENATE This function allows you join two or more strings into one cell. Instructions Combine the text that you see in columns A and B below, into one cell in C. There should be a space between the first name and the last name when you join these texts. CONCATENATE George Washington <== Combine the text in column A and column B into this cell Mary Lincoln Richard Nixon

Explanation / Answer

Answer

Rows

A

B

C

D

2

George

Washington

George Washington

3

Mary

Lincoln

Mary Lincoln

4

Richard

Nixon

Richard Nixon

With Formula, it will look like this----

A

B

C

D

2

George

Washington

=CONCATENATE(B2," ",C2)

3

Mary

Lincoln

=CONCATENATE(B3," ",C3)

4

Richard

Nixon

=CONCATENATE(B4," ",C4)

Rows

A

B

C

D

2

George

Washington

George Washington

3

Mary

Lincoln

Mary Lincoln

4

Richard

Nixon

Richard Nixon

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.