I need a VBA that will:
1 / Search in column "A" for words containing the last letter "m".
2/ If found. Replace the last letter in each word with "s"
Why this request?
In my Arabic language, there is a complex letter that is formed according to the position of the word. Replacing everyone does not work, you will spoil the words
If this letter comes at the beginning of the word or in the middle, there is no error. But at the end of the word, people write it in two forms, and this causes a problem when searching
1 / Search in column "A" for words containing the last letter "m".
2/ If found. Replace the last letter in each word with "s"
Why this request?
In my Arabic language, there is a complex letter that is formed according to the position of the word. Replacing everyone does not work, you will spoil the words
If this letter comes at the beginning of the word or in the middle, there is no error. But at the end of the word, people write it in two forms, and this causes a problem when searching