Concatenate cells, If length is greater then X, Concatenate different cells

[CB5]

Hello,
My goal is to concatenate two cells, if the length of the concatenated values is greater then 30 characters then concatenate a different set of cells. Here was my attempt, but i'm running into issues.

=IF(LEN(A2>30,(CONCATENATE(B2, " ",E2)),(CONCATENATE(B2, " ",F2))

Is this possible to do without running into circular reference?

Thanks

[shg]

=B2 & " " & IF(LEN(A2) > 30, E2, F2)

It can't go in any of those four cells.

[63falcondude]

concatenate two cells, if the length of the concatenated values is greater then 30 characters then concatenate a different set of cells.

With the first set of cells being A1 and B1 and the second set of cells being C1 and D1, try this:

=IF(LEN(A1&" "&B1)>30,C1&" "&D1,A1&" "&B1)

If this is not what you were looking for, please upload a sample workbook with some examples for us to go off of.

[shg]

You're missing an ampersand, fd, but I expect that's a better interpretation.

[63falcondude]

Good catch shg. Fixed.

[CB5]

Thanks shg and falcondude this provided what I needed.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.