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?

A	B	C	D	E	F
sl no	unique id	name	contact	dob	father name
1		ramesh	9865756891	12.04.89	madhav
2		james	8798659785	16.07.91	mathew
3		shashank	9876598615	15.10.95	manav
4		dileep	5687598654	01.02.90	vikash
5

<tbody>
</tbody>

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[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..