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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]A1[/TD]
[TD]B1[/TD]
[TD]C1[/TD]
[/TR]
[TR]
[TD]apple[/TD]
[TD]A lot of apples[/TD]
[TD]A lot of .....s[/TD]
[/TR]
[TR]
[TD]interest[/TD]
[TD]I've interested in giving examples[/TD]
[TD]I've ........ed in giving examples[/TD]
[/TR]
</tbody>[/TABLE]

 

[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
apple	A lot of apples	A lot of .....s
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>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]

</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.