Need help with a simple formula that I could enter into column A that would look in a range of cells in which the values are all blank with the exception of one with text, and then return the text in that cell.

Column A, B, C, D, E, F, etc. and the corresponding values are:
Row 1=Desired Formula, blank, blank, blank, Revenue, blank, blank -The desired formula in column A would return "Revenue"
Row 2=Desired Formula, blank, blank, blank, blank, Trucking, blank -The desired formula in column A would return "Trucking"
etc.

Happy to attach a spreadsheet if needed.

Thanks!