Question: In cell E 2 use CONCATENATE to create the sentence. Ken wants the sentence to read: Today is Wednesday and we sold 2 7 Yeti

In cell E2 use CONCATENATE to create the sentence. Ken wants the sentence to read: Today is Wednesday and we sold 27 Yeti Ramblers. Where Wednesday is the value in cell C2 and the 27 is the value in cell B2. Copy the formula in cell E2 to the bottom row in row 91. Hint: You can use the following pattern to patch the 5 required chunks of text into one coherent sentence. Make sure to include spaces in the appropriate spots.
Chunk 1: "Today is "
Chunk 2: C2
Chunk 3: " and we sold "
Chunk 4: B2
Chunk 5:" Yeti Ramblers."

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!