Another way, making it easier to see how many spaces you are using:

=CONCATENATE(A1,REPT(" ",5),B2,REPT(" ",4),C3,REPT(" ",6),D4)


"Derek M" wrote in message
...
Hi all

I would like to do this in excel and wonder if its possible

In cell a1 i have 1234 in b2 i have an address in c3 i have 600.00 and in
d4
i have 1

I have to have them concatenated but also i need 5 spaces after the first
cell, 4 spaces after the second and 6 spaces after the third when
concatenated (hope this makes sense)

So it would look like this in a1 eventually:

1234 47 Beufort drive 600.00 1

Hope someone might be abke to help as i have 685 lines of this to do :)

Thanks in advance

Derek