how to get unique Id based on data in multiple coloum

[beinggovinda]

I want to generate unique Id in column B, based on data in column C, D , E , F.
I want first letter of Column C, first 2 letters of column F then all the digits of coumn E (digits only without . dot). can anyone please help?

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[/TR]
[TR]
[TD]sl no[/TD]
[TD]unique id[/TD]
[TD]name[/TD]
[TD]contact[/TD]
[TD]dob[/TD]
[TD]father name[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]ramesh[/TD]
[TD]9865756891[/TD]
[TD]12.04.89[/TD]
[TD]madhav[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]james[/TD]
[TD]8798659785[/TD]
[TD]16.07.91[/TD]
[TD]mathew[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]shashank[/TD]
[TD]9876598615[/TD]
[TD]15.10.95[/TD]
[TD]manav[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD]dileep[/TD]
[TD]5687598654[/TD]
[TD]01.02.90[/TD]
[TD]vikash[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 514"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[louisH]

Hi,

very ez.

In B2 then copy down :

=LEFT(C2,1)&LEFT(F2,2)&SUBSTITUTE(E2,".","")

 

[beinggovinda]

thanks louisH..

 

[beinggovinda]

one more thing, i want it to be always comes in Upper case in B2 irrespective of font in column C and D.

 

[louisH]

Here :

=UPPER(LEFT(C2,1)&LEFT(F2,2)&SUBSTITUTE(E2,".",""))

 

[beinggovinda]

thanks a lot. u r a genius.

 

[beinggovinda]

and what if i want first 4 letters of Column C, last 6 letters of column D then first 4 digits of coumn E (digits only without . dot).

 

[louisH]

This :

=UPPER(LEFT(C2,4)&RIGHT(D2,6)&SUBSTITUTE(E2,".",""))

 

[beinggovinda]

thnx once again..