Create UDF that remove specific characters

Hello everyone
In Arabic the letters system is different from English. The letters may be sometimes have addition of special characters (separated from the original letter)
I need a UDF that removes those characters
Example: the word "أَظْهَرَ" is the word with those special characters ... I need to return the same word without those special characters .. in that way "أظهر"

Please help me in this topic. I think it may be solved using Ascii excluding the undesired characters
Thanks advanced for help

The issue posted at this link first
http://www.eileenslounge.com/viewtop...206194#p206194

What part of putting this UDF together would you need help with? The hardest part, IMO, is looking up the UNICODE character numbers for the "letter + special" and the "letter alone" characters. Once you have those values, then it should be a simple Replace() function in VBA or a SUBSTITUTE() function if you want to use native Excel functions.
Replace function help file: https://msdn.microsoft.com/en-us/lib.../gg264409.aspx

If it helps get you started, I used the AscW() function in VBA to find that the 2nd character in your first string is unicode #1614 decimal/64E hexadecimal. The 2nd character in the replaced string is unicode # 1592 decimal/638 hexadecimal. So a statement like newstring=replace(inputstring,chrw(1614),chrw(1592)) would make this replacement. I would expect the UDF to look something like

function replacechar(instring as string) as string
'code to build array of characters to search for
'code to build array of characters to replace
for each character in search/replace arrays
newstring=replace(instring,search character,replace character)
next character
replacechar=newstring
error checking as needed
end function

The hardest (because it is tedious) is searching through the Unicode character lists to get the character codes and putting those characters into arrays. Wikipedia has this list: https://en.wikipedia.org/wiki/Arabic_script_in_Unicode I'm sure there are others.

Thanks a lot MrShorty for reply
I tried that function and it worked for the example provided

Function FnReplace(S As Range) As String
    Dim O, R, N As Long, T As String
    T = S.Value

    O = Array("َ", "ْ", "ً")
    
    R = Array("", "", "")

    For N = LBound(O) To UBound(O)
        FnReplace = Replace(T, O(N), R(N)): T = FnReplace
    Next N

    FnReplace = T
End Function

And it worked well .. but in fact I can't store those special characters in an array as those special characters are much
Can you have a look at the Unicode table to do that if possible?

but in fact I can't store those special characters in an array as those special characters are much

I'm not understanding what difficulty you are having. Looking at the eileen's lounge thread, it appears that you are having difficulty with the tedious part of reading and typing in the characters and codes. I cannot tell if it is simply "it is too long and tedious and I get bored doing it" or if there is some other difficulty in reading the UNICODE tables at wikipedia. If you are having trouble reading wikipedia's unicode tables, there are others out there.

Your sample list in the other forum did not include any of the Arabic characters, but did include the Latin characters. Is the problem larger than originally indicated, in that you don't want to limit this to just the Arabic characters, but the entire Unicode list where accent and other special marks are part of the character? Other than being longer and more tedious, I don't know that this problem is more difficult.

One thing I noticed in the spreadsheet on the other forum is that you used the CHAR() function -- which is limited to Ascii character codes. In 2013, you have access to the built in UNICHAR() (and UNICODE()) functions. https://support.office.com/en-us/art...90033e188#bm21 Paste your code list into Excel like you started, then use the UNICODE() function instead of the CODE() function to get the list of decimal Unicode() numbers for each character. That will even give you the beginnings of a lookup table that you might be able to use.

Does any of that help? What are you stuck on?

I am sorry MrShorty for being late in reply. Thanks a lot for your guidance
The problem is solved efficiently by Mr. Hans using ASCW method

Thank you very much for helping me