I'm new to Excel. I have a Laser measurer recording results in a spreadsheet:

- Each row in
`D:G`

contains a single populated column and the remaining columns are empty. - The column that is populated varies by row.

I have formula that converts the value to a string listing feet and inches.

For example, in row `10`

where the value is in column `F`

, my formula is:

```
=INT(F10/12)&"' "&MOD(F10,12)&"""
```

This formula works but I have to know the column number in advance.

I want to adapt the formula to work for all rows regardless which column is actually populated.