excel formula: search a range of cells and return the value of the only non-blank cell

excel formula: search a range of cells and return the value of the only
non-blank cell

This should be an easy formula but for some reason, i can't figure it out.
I have many rows with formulas and each row spreads over many columns
(e.g. A-Z). However, in each row, there is only one value in one of the
columns and all other columns are blank.
I need a formula that will search each row of data (e.g. A1:Z1) and return
me the value of the only 'non-blank' cell.
why can't i figure this out? thanks.