Checking to see if the data is text or a number in peek
Is there a way when using the peek function to check whether the field before it is text or a number? I have an excel file where the data has been placed in such a way that the first column has the person's name in it and then underneath it is the data relating to that person. I would like to be able to assign that person's name to the data without cutting and pasting to change the excel files layout before loading. Is that possible?