Excel

[gayanwin]

09211 0651 1 Machan Meke Red Color Number Eka Ain Karala Space Tika Ain Karaganan Formula Ekak Kiyala Dennako

 

[*danushka*]

anik number walath "0" da ain karanna ona ehema naththan 6 weni number ekada ?

---

09211 0651 1 Machan Meke Red Color Number Eka Ain Karala Space Tika Ain Karaganan Formula Ekak Kiyala Dennako

=LEFT(SUBSTITUTE(A1, " ", ""), 5) & MID(SUBSTITUTE(A1, " ", ""), 7, LEN(SUBSTITUTE(A1, " ", ""))-7)
------ Post added on Nov 16, 2023 at 8:55 AM

 

[tclanki]

https://elakiri.com/threads/excel-help.2125313/#post-29259720

 

[gayanwin]

anik number walath "0" da ain karanna ona ehema naththan 6 weni number ekada ?

---

=LEFT(SUBSTITUTE(A1, " ", ""), 5) & MID(SUBSTITUTE(A1, " ", ""), 7, LEN(SUBSTITUTE(A1, " ", ""))-7)
------ Post added on Nov 16, 2023 at 8:55 AM

Machan Meka Hari Giya Anthimata Thiyana 1 Number Ekath Ain Wenawa

 

[*danushka*]

Machan Meka Hari Giya Anthimata Thiyana 1 Number Ekath Ain Wenawa

try
=LEFT(A1, FIND("0", A1)+2) & MID(A1, FIND("0", A1)+4, LEN(A1)-FIND("0", A1)-4)

 

[gayanwin]

try
=LEFT(A1, FIND("0", A1)+2) & MID(A1, FIND("0", A1)+4, LEN(A1)-FIND("0", A1)-4)

Na MAchan

 

[kavindagk]

=TRIM(SUBSTITUTE(SUBSTITUTE("09211 0651 1"," 0","")," ",""))

 

[gayanwin]

=TRIM(SUBSTITUTE(SUBSTITUTE("09211 0651 1"," 0","")," ",""))

mACHAN rED cOLOR zERO eKA aIN wELA sPACE aIN wENNA oNE mACHAN

 

[Hasistranger]

bump

 

[kavindagk]

View attachment 219119

mACHAN rED cOLOR zERO eKA aIN wELA sPACE aIN wENNA oNE mACHAN

mama ewwa eken eka wenawa ban

=TRIM(SUBSTITUTE(SUBSTITUTE("09201 0644 1"," 0","")," ","")) ----> 092016441

mehema neweine umba enna oni widiyata pahadiliwa dapan, umbe question eke thiyenne RED 0 ain wela SPACE remove karanne , mama ewwa eken eka wenawa

 

[Ozone4]

use this
=SUBSTITUTE(SUBSTITUTE(LEFT(E3,6)&MID(E3,8,5)," ","")," ","")
0 ta kalin tyenne space 1k newei.. ekath ain wenawa above formula 1n.

 

[ramkhan]

=SUBSTITUTE(MID(SUBSTITUTE(A1, " ", ""),1,5) & MID(SUBSTITUTE(A1, " ", ""),7,LEN(A1)), " ", "")

 

[OrangeHat]

bump

 

[gayanwin]

use this
=SUBSTITUTE(SUBSTITUTE(LEFT(E3,6)&MID(E3,8,5)," ","")," ","")
0 ta kalin tyenne space 1k newei.. ekath ain wenawa above formula 1n.

Ela Tanks

 

[*danushka*]

View attachment 219111

Na MAchan

=LEFT(SUBSTITUTE(A1, " ", ""), 5) & MID(SUBSTITUTE(A1, " ", ""), 7, LEN(SUBSTITUTE(A1, " ", ""))-6)

 

[tclanki]