Forum Discussion

LauraJackson's avatar
LauraJackson
Copper Contributor
May 08, 2023
Solved

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

Resources