Find and replace the word in the text

[nitux]

As a newbie I couldn't done it. Sorry for this low level question, I need C1. Thank you.

A1	B1	C1
apple	A lot of apples	A lot of .....s
interest	I've interested in giving examples	I've ........ed in giving examples

<tbody>
</tbody>

 

[JoeMo]

Is this what you want?

Excel Workbook
	A	B	C
1	apple	A lot of apples	A lot of .....s
2	interest	I've interested in giving examples	I've ........ed in giving examples
Sorter

 

[JoeMo]

Is this what you want?
Sorter

*	A	B	C
1	apple	A lot of apples	A lot of .....s
2	interest	I've interested in giving examples	I've ........ed in giving examples

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:56px;"><col style="width:220px;"><col style="width:202px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula C1 =SUBSTITUTE(B1,A1,REPT(".",LEN(A1))) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[nitux]

Thank you @JoeMo! I tried it on thousands of lines, it worked perfectly... I can not tell you how much it benefits me. Also I figured out how it works, there was no complicated solution as I thought.

 

[JoeMo]

Thank you @JoeMo! I tried it on thousands of lines, it worked perfectly... I can not tell you how much it benefits me. Also I figured out how it works, there was no complicated solution as I thought.

You are welcome - thanks for the reply.