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 &
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 is just that this one
is too long for Excel's liking. Thank!