Hi,
I am looking for a formula using which returns the only text from a range. For example if the range I am interested in is column A of a worksheet, then if I type "apple" in any row of that column, this formula should return "apple". The rest of the rows in that column will be blank. Can anyone help me with this?
Thanks,
Rajesh
Bookmarks