How do you concatenate an alphabet to the left of a 5 digit if the EID?

[raghuprabhu]

How do you concatenate an alphabet to the left of a 5 digit if the EID?

In this example, I want to concatenate T (for Technical) to the EID of members in either Hardware or Software.

Thanks...

Regards

Raghu

[Glenn Kennedy]

Do you mean:

=IF(OR(A2=1,A2=2),"T"&B2,B2)

in c2, copied down

[raghuprabhu]

Hi Glen,

Yes, but I want it to be permanent. Suppose the values in column A are accidentally changed, it will cause problem.

I want to Concatenate T to EID

Thanks..
Raghu

[chullan88]

Glenn's solution is working perfectly...

Without any identifier, how could you identify the Section for each EID?

Unless you have a full list of EIDs under each section in a seperate sheet

[raghuprabhu]

Glenn and Chullan88

Thanks...