Ignore All The Dashes And Return The Name Only

[Turk182]

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

 

[FMHasan]

I think this will work.

Mustard Oil SKU.xlsx
	B	C	D	E	F	G	H	I
4
5	Bob				Bob
6	Carol					Carol
7	Ted						Ted
8	Alice							Alice
Sheet2

Cell Formulas
Range	Formula
B5:B8	B5	=IF(F5="","",F5) & "" & IF(G5="","",G5) & "" & IF(H5="","",H5) & "" & IF(I5="","",I5)

I think this will work.

 

[Turk182]

I think this will work.

Mustard Oil SKU.xlsx
	B	C	D	E	F	G	H	I
4
5	Bob				Bob
6	Carol					Carol
7	Ted						Ted
8	Alice							Alice
Sheet2

Cell Formulas
Range	Formula
B5:B8	B5	=IF(F5="","",F5) & "" & IF(G5="","",G5) & "" & IF(H5="","",H5) & "" & IF(I5="","",I5)

I think this will work.

I think this will work.

Mustard Oil SKU.xlsx
	B	C	D	E	F	G	H	I
4
5	Bob				Bob
6	Carol					Carol
7	Ted						Ted
8	Alice							Alice
Sheet2

Cell Formulas
Range	Formula
B5:B8	B5	=IF(F5="","",F5) & "" & IF(G5="","",G5) & "" & IF(H5="","",H5) & "" & IF(I5="","",I5)

I think this will work.

Thx FMHasan. Good resolution, but--as the list and number of rows grow – I am trying to not have to keep up with the column in which the name appears.