Find and Replace _ using additional characters|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi, all

I have a small question, just to get the point.

Usually, there is a function in the excel "find and replace". My question is, if we have any text data and would like to use the tab "replace" the following is happening:

Example: (just copy and check into your workbook)

cat

cot 

cats

If we would like to replace some of them using the "~c?t", replacing by "cass", the result per below:

cass

casss

My question, why additional "s" is added? (in first case(word) no)

(do not create a workbook as i believe its a simple question  with the simple example)

Thank you in advance.