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...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    May 08, 2023

    LauraJackson 

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

    Does this return the intendend result? 

OliverScheurich's avatar
OliverScheurich
Gold Contributor
May 08, 2023

LauraJackson 

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

Does this return the intendend result? 

LauraJackson's avatar
LauraJackson
Copper Contributor
May 08, 2023
Yes it does - thank you so much!

Resources