Hi
I have a sheet with a column of list of words in different languages I want to get only Arabic words and put them in different row
For example:
input
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px 'Helvetica Neue'; color: #000000}span.s1 {font-kerning: none}span.s2 {font: 10.0px 'Geeza Pro'; font-kerning: none}</style>1- Sharifah,Sharīfah,shryft,شريفة
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px 'Helvetica Neue'; color: #000000}span.s1 {font-kerning: none}span.s2 {font: 10.0px 'Geeza Pro'; font-kerning: none}</style>2- Umm al `Ulaymat,Umm al ‘Ulaymāt,`Awayid,am almymat,أم الميمات,عوايد,‘Awāyid
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px 'Helvetica Neue'; color: #000000}span.s1 {font-kerning: none}span.s2 {font: 10.0px 'Geeza Pro'; font-kerning: none}</style>3- Al Jamaliyah,[FONT="]جمالية[/FONT],Al Jamālīyah,Jamaliyah,Jamālīyah,aljmalyt,jmalyt,الجمالية
output:
row 1: [FONT="]شريفة
row 2: [/FONT]أم الميمات[FONT="]
row 3: [/FONT][FONT="]عوايد
[/FONT][FONT="]row 4: [/FONT][FONT="]الجمالية[/FONT][FONT="]
row 5: [/FONT][FONT="]جمالية
[/FONT][FONT="]Thank you in advance
[/FONT]
I have a sheet with a column of list of words in different languages I want to get only Arabic words and put them in different row
For example:
input
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px 'Helvetica Neue'; color: #000000}span.s1 {font-kerning: none}span.s2 {font: 10.0px 'Geeza Pro'; font-kerning: none}</style>1- Sharifah,Sharīfah,shryft,شريفة
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px 'Helvetica Neue'; color: #000000}span.s1 {font-kerning: none}span.s2 {font: 10.0px 'Geeza Pro'; font-kerning: none}</style>2- Umm al `Ulaymat,Umm al ‘Ulaymāt,`Awayid,am almymat,أم الميمات,عوايد,‘Awāyid
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px 'Helvetica Neue'; color: #000000}span.s1 {font-kerning: none}span.s2 {font: 10.0px 'Geeza Pro'; font-kerning: none}</style>3- Al Jamaliyah,[FONT="]جمالية[/FONT],Al Jamālīyah,Jamaliyah,Jamālīyah,aljmalyt,jmalyt,الجمالية
output:
row 1: [FONT="]شريفة
row 2: [/FONT]أم الميمات[FONT="]
row 3: [/FONT][FONT="]عوايد
[/FONT][FONT="]row 4: [/FONT][FONT="]الجمالية[/FONT][FONT="]
row 5: [/FONT][FONT="]جمالية
[/FONT][FONT="]Thank you in advance
[/FONT]