VBA to replace the last character with a different character

idres

New member
Joined
Jul 22, 2021
Messages
2
Reaction score
0
Points
0
Excel Version(s)
2013
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 searching33.jpg
 
Back
Top