Excel formula help

[HRA]

machanla

LA/B4/ 01/10
LA/B4/02/10
LA/B4/03/10

me widihata red coulor no 01 02 03 widihata continue karaganna Formula ekak hadala denna puluwanda? LA/B4/01/10 kiyanne eka sell ekaka thiyena data

 

[HRA]

bump

thanks

 

[chandima3010]

machanla

LA/B4/ 01/10
LA/B4/02/10
LA/B4/03/10

me widihata red coulor no 01 02 03 widihata continue karaganna Formula ekak hadala denna puluwanda? LA/B4/01/10 kiyanne eka sell ekaka thiyena data

puluwan ban use text colors

 

[HRA]

puluwan ban use text colors

no machan thats not i want

mama kiuwwe oya red colour walin highlight karala thiyena no set eka eka digata count wenna(1,2,3,4,and so on) formula ekak.

 

[*danushka*]

no machan thats not i want

mama kiuwwe oya red colour walin highlight karala thiyena no set eka eka digata count wenna(1,2,3,4,and so on) formula ekak.

bari wena ekak na poddak inna.oyata " / " ekath anna onada.madata ??????

 

[HRA]

bari wena ekak na poddak inna.oyata " / " ekath anna onada.madata ??????

yes machan

 

[*danushka*]

yes machan

wait machan i'm trying.

 

[chathu_ac]

mama danna widitaya 1 step eken karanna ba wage
A cell eke LA/B4/01 continue karanna
B cell eke 10 dala continue karanna
C cell eke me fomula eka ghanna =CONCATENATE(A1,"/",B1)
ita passe ona thanata C column ela special pasta karanna

 

[da-one01]

oooka simple ne

public class XL {
public static void main(String args[]) {
for(int i=1;i<100;i++) {
System.out.println("LA/B4/"+ i +"/10");

}
}

 

[gudaya]

bump machan

 

[*danushka*]

machanla

LA/B4/ 01/10
LA/B4/02/10
LA/B4/03/10

me widihata red coulor no 01 02 03 widihata continue karaganna Formula ekak hadala denna puluwanda? LA/B4/01/10 kiyanne eka sell ekaka thiyena data

hear u go machan.

="LA/B4/"&TEXT(ROWS($A$1:A1),"00")&"/10"

 

[HRA]

mama danna widitaya 1 step eken karanna ba wage
A cell eke LA/B4/01 continue karanna
B cell eke 10 dala continue karanna
C cell eke me fomula eka ghanna =CONCATENATE(A1,"/",B1)
ita passe ona thanata C column ela special pasta karanna

thanks buddy
but *danushka* s way is easy but you also helped me so rep added

 

[HRA]

hear u go machan.

="LA/B4/"&TEXT(ROWS($A$1:A1),"00")&"/10"

yeah that works thanks machan rep added

 

[*danushka*]

yeah that works thanks machan rep added

glad to help u machan....

 

[dinukamp]

got to vbforums.com

its very help full forum exce..

 

[HRA]

thanks buddy
but *danushka* s way is easy but you also helped me so rep added

sorry bro, rep denna balu mama kalin eka wathawak oyata rep dila thiyena hinda
anyways thaks for da help