I need a formula to eneter a word in a sentence from another column

[watsonjp]

Good Day,

I have in column "C" the following word "Wimpey Chairs" and in column "DR" I have the following sentence "

Shop at Office Stock, carrying a huge selection of quality furniture and office supplies." So I am looking for a formula where I can enter the words in column "C" in the sentence in column "DR" just after the first word that will be Shop. So when completed the sentence will read "Shop Wimpey Chairs at Office Stock, carrying a huge selection of quality furniture and office supplies." I want to drag this formula down so that it can take every time the word in a row in the specific column and add it automatically to the sentence in a specific position. The sentence will always stay the same but as we move down in the rows the word will change every time.

<tbody>
</tbody>

 

[mrhstn]

Perhaps like this...


=LEFT(DR2, FIND(" ", DR2))&C2&MID(DR2, FIND(" ", DR2), 255)

 

[Fluff]

How about
=REPLACE(DR1,5,," "&C1)

 

[Peter_SSs]

Welcome to the MrExcel board!

Is this what you want?
Formula copied down.

Excel 2016 (Windows) 32 bit
	C	DQ	DR	DS
2	Wimpey Chairs		Shop at Office Stock, carrying a huge selection of quality furniture and office supplies.	Shop Wimpey Chairs at Office Stock, carrying a huge selection of quality furniture and office supplies.
3	Table			Shop Table at Office Stock, carrying a huge selection of quality furniture and office supplies.
4	Something else			Shop Something else at Office Stock, carrying a huge selection of quality furniture and office supplies.
Insert word

Cell Formulas
Range	Formula
DS2	=SUBSTITUTE(DR$2," "," "&C2&" ",1)