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.
Hi,
The 3rd word in your list is cats and ~c?t matches the cat part, so replacing cat with cass you get casss
cats
casss
Regards
Phil
Hi,
Daria Spiteri,
I hope your problem will be solved.
You can check the attached file.
Thank you, i guess that i missed the point of formulated expression.
