View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hans hans is offline
external usenet poster
 
Posts: 36
Default Sorting the first text in a row

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