Look in range and copy cell that contains text

I have been searching around and have found lots of help creating a formula that will search a range of cells for specific text. That is what I want but not so specific with the text. I have a range of cells (B1:E1), and one cell contains text the other three have 0's. The text is one of 7 possibilities so I would prefer to keep the formula simple and just copy what ever the text is in to F1.
so we need to look in range B1:E1 and find the cell that has text and copy and paste that text into cell F1. This is a simple example. The range could be much larger but you get the idea. It should be a simple if then string but I can't make it work.

This is what I wrote but I just get a blank return.

Please Login or Register  to view this content.

I think the below will work for you

=LOOKUP("ZZZZZ",B1:E1)