Concating cells in range if condition exists

[JimS63]

I have a range of cells, some merged that contain customer information. If the customer is attending or has a video demo I want a single cell that shows all the customers involved.

My cells look like the picture attached.

I want the last column to show all the customers to the left that have customer or video on the last line.

I have tried to put this code into a function in VBA

IF(ISNUMBER(SEARCH("abc",A1:L5)),A1:L5,"")

to see if the cell contains the text and then

 LEFT(T11,FIND("*",T11,2)-1)

to return the customer name.

I keep getting errors and haven't been able to figure this out.

Can anyone help me with a function module that I could use on a second sheet to create a list of customer blocks

Thanks

 

[JimS63]

So I am using this code now and can get a range of cells to the right that give me the output I want. However I would like to concat all the cells into one cell with CHR(10) between names

= IF(ISNUMBER(SEARCH("Customer",O14:AG14)),LEFT(O14:AG14,FIND("*",O14:AG14,2)-1),"")

Any help there?