IF function that searches one column and lists the results in a paragraph

Dear Pete_UK,

Thank you for the link. I gone through the link. I found the formula is based on 'Number' and my formula is based on "Text", how to convert it for text? Will explain please for me!