Counting names in the cell, including Compound name in the Arabic language
Compound Name:
- Is the name that starts ( Abd, Abu, Ben, ....)
Counting names in the cell, including Compound name in the Arabic language
Compound Name:
- Is the name that starts ( Abd, Abu, Ben, ....)
I don't see how this is possible, unless there is a rule, that excel can interpret, which tells it that a name is Arabic... It may be a coincidence that the first name is 3 letters long, but there areplenty of "western" names that have three letters (Ian, Sam, Jon, etc).
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Unfortunately, Compound name in Arabic is preceded by the name "Abu, Abd, Ben."
The name that comes after it becomes part of it, is both one name
see the attached file
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Genius solution
This is exactly who I want
Thank you Mr "nflsales"
A little knowledge of Arabian names clearly helps!
These are some examples of compound names
Abd ElAlrjmn
Abd ElJalil
Om Ali
Ben Gasser
Abu Allam
Bu aziza
Jalal Elddin
Izz alDin
Why Mr "nflsales" when repeat the name Compound is given in error count
Such as:
Abd elChrist Peter Charles Abd elChrist
Give me the number "5"
With the correct number "4"
see the attached file
Yes you did it
Now the formula works like a charm.
Thank you very much, Mr. "Siva"
You are a very nice man
Thank you Shimaa
Glad to help you
I am very sorry mister "Siva"
Can be converted to " UDF" formula
Thank you again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks