Hello James,

Great formula. It works very well.

Many thanks


Low


--
A36B58K641


"Zone" wrote:

Here is one way to do it. For the first set of account codes, put this in
cell B1:
=A1&".02.GT.0215"
and drag it down column B.
For the second set of account codes, put this in cell F1:
=A1&"."&B1&"."&C1&"."&D1&"."&E1
and drag it down column F.
HTH,
James

"Mr. Low" wrote in message
...
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