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 E use CONCATENATE to create the sentence. Ken wants the sentence to read: Today is Wednesday and we sold Yeti Ramblers. Where Wednesday is the value in cell C and the is the value in cell B Copy the formula in cell E to the bottom row in row Hint: You can use the following pattern to patch the required chunks of text into one coherent sentence Make sure to include spaces in the appropriate spots.
Chunk : "Today is
Chunk : C
Chunk : and we sold
Chunk : B
Chunk : Yeti Ramblers."
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
