Insert text in concatenate

[LauraJackson]

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 · Accepted solution]

@LauraJackson 

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

Does this return the intendend result? 

[#3]

Yes it does - thank you so much!