Excel help ( Advanced Filtering )

[lk-maare]

USD- KNIT M TJW18
USD-HOODIE M TJW
USD-HOODIE M TJW
USD- KNIT M TJW18
USD- TJW18 KNIT


me wage series ekaka anthima wachane filter karaganne kohomada ?

series eke search wenna oni last word eke starting eka TJW eeta passe any series of characters.
dan methana widihata mata anthima eka ayin wenna oni mokada eke enne knit kiyala hinda.
anthima wachane kohomada filter karaganne hithanna bari.


ekama series ekak nan TJW?? dammanan enawa. methana awula smahara welawata TJW2222 wage awoth result eken ayin wenwa.


mata oni mokak hari awulak na anthiama wachane witharak TJW thiyenawanan filter wenna.

 

[wolvoring]

Simpal ban uba pavichi karana excel version eka mokakda

 

[bonji]

USD- KNIT M TJW18
USD-HOODIE M TJW
USD-HOODIE M TJW
USD- KNIT M TJW18
USD- TJW18 KNIT


me wage series ekaka anthima wachane filter karaganne kohomada ?

series eke search wenna oni last word eke starting eka TJW eeta passe any series of characters.
dan methana widihata mata anthima eka ayin wenna oni mokada eke enne knit kiyala hinda.
anthima wachane kohomada filter karaganne hithanna bar


ekama series ekak nan TJW?? dammanan enawa. methana awula smahara welawata TJW2222 wage awoth result eken ayin wenwa.


mata oni mokak hari awulak na anthiama wachane witharak TJW thiyenawanan filter wenna.

anthima 4 letters walatada filter karanna one

 

[bonji]

USD- KNIT M TJW18
USD-HOODIE M TJW
USD-HOODIE M TJW
USD- KNIT M TJW18
USD- TJW18 KNIT


me wage series ekaka anthima wachane filter karaganne kohomada ?

series eke search wenna oni last word eke starting eka TJW eeta passe any series of characters.
dan methana widihata mata anthima eka ayin wenna oni mokada eke enne knit kiyala hinda.
anthima wachane kohomada filter karaganne hithanna bari.


ekama series ekak nan TJW?? dammanan enawa. methana awula smahara welawata TJW2222 wage awoth result eken ayin wenwa.


mata oni mokak hari awulak na anthiama wachane witharak TJW thiyenawanan filter wenna.

Thawa column 1 add karala data extract karaganna then ubata filter karaganna puluwan

 

[mtmadushanka]

 

[soldierthilina]

Step 01 :Column eka select karala..CTR+F..Replace TAB..Find what:Space ekak thiyapan..Replace with:Monawath karana epa..Replace All..

Step 02 :Column eka select karala..Data TAB..Text to Column..Fixed with..Next..Ona thanakata thiyala split karaganin

 

[lk-maare]

Simpal ban uba pavichi karana excel version eka mokakda

2016
eeye hadissiyata anthima wachane trim karala manually filter karan giya

anthima 4 letters walatada filter karanna one

lettersma newei machan.meke akuru gaana hariyatama kiyanna ba. sequence ekak thamai bn ganna wenne.
mam ara filter eke contains gihin TJW* diila baluwa hari giye na. characters gaana hariyatama hari nan TJW?? dipuhama hari. meka ehemama na bn ekai awula giye.

bump

Thawa column 1 add karala data extract karaganna then ubata filter karaganna puluwan

meka balanna oni. mam eeye trim kara bn anthima wachane allala.

Step 01 :Column eka select karala..CTR+F..Replace TAB..Find what:Space ekak thiyapan..Replace with:Monawath karana epa..Replace All..

Step 02 :Column eka select karala..Data TAB..Text to Column..Fixed with..Next..Ona thanakata thiyala split karaganin

=TRIM(RIGHT(SUBSTITUTE(E2," ",REPT(" ",100)),100))
meken karana eka ne bn oye
anthimata oke thamai kare bn

 

[wolvoring]

Oya reddawal oni naha ban ehenm filter ekata gihin uba anthima akuru 4ra type karapan etha kota lassanata filter wei

 

[Dishta Didin]

bump

 

[lk-maare]

Oya reddawal oni naha ban ehenm filter ekata gihin uba anthima akuru 4ra type karapan etha kota lassanata filter wei

ba machan. anthima akuru tika ekama widihata enne na.
smahara welawata tjw1 witharak enawa.tjw witharak enawa. oni ban eke seq eka ganna.

anthima wachne TJW walin nan patan ganne anna e tika pick wenna oni.


ex : -



USD- KNIT M TJW18
USD-HOODIE M TJW
USD-HOODIE M TJW
USD- KNIT M TJW18
USD- TJW18 KNIT
USD- KNIT M TJW1
USD- KNIT M TJW
USD- TJW18 KNIT


me wage awoth filter wenna oni TJW walin thiyena okkoma. kalu akuren thiyena okkoma filter wenna oni