How can I replace a word from a sentence in a cell and substitute the word from another cell.
example:
A1 > apple
A2 > banana
A3 > carrot
.
.
A100 > grape
B1 > I ate food this morning (using ONLY cell B1 as source of sentence)
**this is the OUTPUT after replacing word "food"
C1 > I ate apple this morning
C2 > I ate banana this morning
C3 > I ate carrot this morning
.
.
C100 > I ate grape this morning
example:
A1 > apple
A2 > banana
A3 > carrot
.
.
A100 > grape
B1 > I ate food this morning (using ONLY cell B1 as source of sentence)
**this is the OUTPUT after replacing word "food"
C1 > I ate apple this morning
C2 > I ate banana this morning
C3 > I ate carrot this morning
.
.
C100 > I ate grape this morning
Last edited: