Along a single row, I've got a number of columns, only one of which will contain text. I need to be able to find the one cell in there with text, and return that text into another cell.


In need column E to return "Melitta" in row 2, and "Nespresso" in row 3.

1 Answer 1


Figured it out....CONCATENATE does the job if you include the entire range.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.