I currently have this function:

=IF(AO116="1) Agent did not identify the beneficiary's likes & dislikes.,2) Agent did not ask or acknowledge they understand the beneficiary's current coverage.,3) Agent failed to collect enough information to recommend a suitable plan.,4) Agent recommended a plan that is not suitable for the beneficiary's needs.,6) Other compliance issue.", "1) Agent did not identify the beneficiary's likes & dislikes.", “0”)


However, this is over the 255 char limit. How can I use this in conjunction with the CONCATENATE function per the instructions in Excel? This code works, and is what I want to happen. It's just that this one is too long for Excel's liking. Thank!