Formula to Return the Text in a Range of Cells

[alohadboy]

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!

[Glenn Kennedy]

Maybe just this:

=B1&C1&D1&E1&F1&G1

[alohadboy]

That works. Thanks.

[Glenn Kennedy]

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.