Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting different strings of text | New Users to Excel | |||
Sorting (Numbers with Text) | Excel Discussion (Misc queries) | |||
help with text sorting | Excel Worksheet Functions | |||
Sorting Text | Excel Discussion (Misc queries) | |||
sorting of text | Excel Discussion (Misc queries) |