Horizontal Search

Hi . . .

I am having trouble trying to find the right formula to search each horizontal row for the number "4".

I need the formula to return the Column that the "4" is in or the Columns as sometimes there is more than one "4" in the row.

Column A in the attached sheet is where the formula needs to go and we search the columns C to AH for each row.

Thanks

Nick