Rubber Beaked Woodpecker
Board Regular
- Joined
- Aug 30, 2015
- Messages
- 210
- Office Version
- 2021
Hi all 
If possible I'm hoping someone can kindly provide a formula for the following please;
In Z1 I would like a formula to look at the range U6:AJ15 and return the text of the first cell that contains text.
Hope this makes sense
Thanks RBW

If possible I'm hoping someone can kindly provide a formula for the following please;
In Z1 I would like a formula to look at the range U6:AJ15 and return the text of the first cell that contains text.
Hope this makes sense

Thanks RBW