SOLVED

# Insert text in concatenate

Copper Contributor

# Insert text in concatenate

Hi everyone,

I need some assistance please with an IF formula.

If cell Q2 has a value of "Full" then populate "Full".  Else, concatenate C2&D2&E2&F2&G2&H2&I2. What I need help with is inserting semi colons between C2, D2, etc.

Here is my formula so far:

=IF(Q2="Full","Full",C2&D2&E2&F2&G2&H2&I2)

It ends up looking like this: PropertyManagementPropertyManagementPropertyManagementProperty

It works beautifully except the values for C2&D2&E2&F2&G2&H2&I2 need to be separated by semi colons. I tried modifying my formula to this, but it is not recognizing it:

=IF(Q2="Full","Full",C2";"&D2";"&E2";"&F2";"&G2";"&H2";"&I2)

In my spreadsheet it displays the entire formula as text. Any thoughts?

2 Replies
best response confirmed by LauraJackson (Copper Contributor)
Solution

# Re: Insert text in concatenate

``=IF(Q2="Full","Full",C2&";"&D2&";"&E2&";"&F2&";"&G2&";"&H2&";"&I2)``

Does this return the intendend result?

# Re: Insert text in concatenate

Yes it does - thank you so much!
1 best response

Accepted Solutions
best response confirmed by LauraJackson (Copper Contributor)
Solution

# Re: Insert text in concatenate

``=IF(Q2="Full","Full",C2&";"&D2&";"&E2&";"&F2&";"&G2&";"&H2&";"&I2)``

Does this return the intendend result?