How to find things in Excel

Search the range A1 to A10 for the first cell which contains text, and show that text
=hlookup("*",A1:A10,1,false)