Dear Sir,

Lets consider the following worksheet:

A B (Answer)
1 2115 2115.02.GT.0215
2 2145 2145.02.GT.0215
3 3245 3245.02.GT.0215
4 4128 4128.02.GT.0215
5 6627 6627.02.GT.0215

I have five account codes in column A and need to add extention .02.GT.0215
as illustrated in column B above.

May I know what formula to be input at B1 and copy down to get the straight
answer ?

In another instance I have the folowing worksheet:

A B C D F (Result)
1 2115 02 GT 0224 2115.02.GT.0224
2 2145 06 KU 0386 2145.06.KU.0386
3 3245 08 ST 0455 3245.08.ST.0455

I need to add the extentions for content in column B,C,D to the codes in
column A. Is there any formula I can key in at column F to get the result I
needed ?

Thanks

Low

--
A36B58K641