View Single Post
  #3   Report Post  
Old May 28th 10, 02:42 PM posted to microsoft.public.excel.worksheet.functions
Steve Dunn Steve Dunn is offline
external usenet poster
First recorded activity by ExcelBanter: Mar 2010
Posts: 193
Default Concatenate with a specific number of spaces


you even know the name of the function required...

=CONCATENATE(A1," ",B2," ",C3," ",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
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