=IF(COUNTA(1:1),INDEX(1:1,MATCH("*",1:1,0)),"")


"Hans" wrote:

I have 4 columns with names, in some rows are none to 4 names. The names
appear random in any of the columns. It could look like this:
name1 name2
name3
name 4 name5

I want to get the first name that appears (from left to right) and put it in
the fifth column, like this:
name1
name3
name4

I can't figure it out, any help is welcome