I am trying to solve an issue in excel in which I have a column of data that contains a mix of both letters and numbers. In a new column I would like to extract if and only if the data column contains a cell that has a 10 digit number that starts with a 9 and if not returns blank.

I am trying to solve an issue in excel in which I have a column of data that contains a mix of both letters and numbers. In a new column I would like to extract if and only if the data column contains a cell that has a 10 digit number that starts with a 9 and if not returns blank.

I am trying to solve an issue in excel in which I have a column of data that contains a mix of both letters and numbers. In a new column I would like to extract if and only if the data column contains a cell that has a 10 digit number that starts with a 9 and if not returns blank.

So I have a cell that contains three lists with line breaks separating them:

So I have a cell that contains three lists with line breaks separating them:

So I have a cell that contains three lists with line breaks separating them:

So I have a cell that contains three lists with line breaks separating them:

So I have a cell that contains three lists with line breaks separating them:

So I have a cell that contains three lists with line breaks separating them:

So I have a cell that contains three lists with line breaks separating them: