Concatenating Cells (Excel)

Cotta

Hi All,


Can I concatenate four cells in Excel that are not in order e.g. I want to add cell A1, F1, D1 and B1 in this order. The original cells cannot be adjusted - is this possible?


Thanks

Andy_L

Yes, you just select/type the cell reference in the order you want in the concantenate function

Lokolo

=CONCATENATE(A1, F1, D1, B1)

Surely that works?

lisa110rry

I do Access rather than Excel, but would it not be: =CONCATENATE(A1, " ", F1, " " D1," " B1) or something similar to get the spaces in?

In Access it would be &" "& between the several fields in the concatenation.

Lokolo

Oh I suppose if you need spaces then yes

indesisiv

I have never used the =CONCATENATE(A1, F1, D1, B1) function.
I didn't even know it exists.
I usually just do =(A1 & F1 & D1 & B1)

DoaM

As per post #6. And if you need spaces:

=(A1 & " " & F1 & " " & D1 & " " & B1)

Le_Kirk

If you are concatenating, why would you add spaces?

Jivesinger

Le_Kirk wrote: »

If you are concatenating, why would you add spaces?

It depends on what is being concatenated.

For instance it it's words, then spaces would help.

Also in some scenarios you may want to distinguish 12 345 67 89 from 1 234 567 89 (for example)

DoaM

Le_Kirk wrote: »

If you are concatenating, why would you add spaces?

I'll counter that with, why wouldn't you? Both options are correct - as above it all depends on what is the desired outcome.