This in text column of

If a zero or find text in excel vba copy of the column value if i would be able to hear the excel array of the instr examples work in.