I want to know if it is possible through any function in excel. Eg:-

COL.1 COL.2 COL.3(Answer required)

A 2 AA
B 4 BBBB
C 1 C
D 5 DDDDD

Thanks in advance for your help
Sanjeev