Hello All.
I have an Excel sheet for which MOST cells of each row have a dash ONLY (Columns "G" Thru "P"). ONE cell in the row will have a name (either "Bob", "Carol","Ted", or "Alice").
I need an Excel formula that will ignore all the dashes and return the name only (in whichever column it is found) and place the name in column "A" (formula column) of that row.
Is that possible with just formulas?
Thx, Turk182
I have an Excel sheet for which MOST cells of each row have a dash ONLY (Columns "G" Thru "P"). ONE cell in the row will have a name (either "Bob", "Carol","Ted", or "Alice").
I need an Excel formula that will ignore all the dashes and return the name only (in whichever column it is found) and place the name in column "A" (formula column) of that row.
Is that possible with just formulas?
Thx, Turk182