Return closes adjacent text string in occupied cells

[dunmore83]

I have three columns - lets say A B C. Under these columns there is text in some but not all the cells. In column D I want the text string from the closest occupied cell.

For example if row 1 has text in B1 then that value goes into D1.... if row 2 only hast text in A2 (none in B2 or C2) then the text string in A2 goes into D2.

Any helpers for a formula? Thanks

 

[FDibbins]

Will only 1 cell in the three have contents? If not, which cell do you want returned?

=IF(A1="",if(B1="",C1,B1),A1) will check A1 1st, then B1, then C1

 

[dunmore83]

No all cells can have contents. Want the closest occupied cell to the d column

 

[FDibbins]

OK, so C 1st, then B, then A?

=IF(C1="",if(B1="",A1,B1),C1)