Excel Help

[gayanwin]

09002 0651 2 - මචන් මේ ඉලක්කම් වල රතු පාට බිංදුව අයින් කරල ස්පේස් තැති කර ගන්නෙ කොහොමද එක්සෙල් වල නම්ඉර්ස ගොඩක

 

[MihiCherub]

=CONCATENATE(LEFT(A1,5),MID(A1,8,3),RIGHT(A1,1))

where A1 is your data

 

[kinkon]

Excel

 

[gayanwin]

=CONCATENATE(LEFT(A1,5),MID(A1,8,3),RIGHT(A1,1))

where A1 is your data

Mehema Result Ekakne Ban Awe

 

[tclanki]

uda function ekama tama 100% correct machan oya multiply karanne Mid ekedi machan

 

[gayanwin]

View attachment 216190

uda function ekama tama 100% correct machan oya multiply karanne Mid ekedi machan

Mage Funtion Eka waradida machan mama dunnama mehemane enne

 

[tclanki]

Mage Funtion Eka waradida machan mama dunnama mehemane enne

ow machan oyage function eka waradi. multiply newe comma enna ona machan

 

[EKGuest]

=REPLACE( SUBSTITUTE(A1," ", ""), 6, 1, "")

 

[black]

Mage Funtion Eka waradida machan mama dunnama mehemane enne

oyage cell format 1 mokadda balanna tiyenne