Here are a few of the lines of data.
Each is in one cell in column H on a line.
420BOZ(), 629PZA(), 629GED(), 629ZFA(), 630ZQA(), 630PFA()
430ZZA(), 521ZZA(), 629PZA(), 629GED(), 629ZZA(), 630PEA()
430ZZA(), 521ZZA(), 629PZA(), 629GED(), 629ZZA(), 630ZQA()
532ZZA(), 850JGA(), 850NAA(), 265DEB(), 860SRA(), 860RCA()
In an adjacent cell all I want to do is pull the first 6 digits of the first number that starts with 630.
If there isn't any I want a blank cell.
Can anyone come up with a working formula, I'm stuck.
Each is in one cell in column H on a line.
420BOZ(), 629PZA(), 629GED(), 629ZFA(), 630ZQA(), 630PFA()
430ZZA(), 521ZZA(), 629PZA(), 629GED(), 629ZZA(), 630PEA()
430ZZA(), 521ZZA(), 629PZA(), 629GED(), 629ZZA(), 630ZQA()
532ZZA(), 850JGA(), 850NAA(), 265DEB(), 860SRA(), 860RCA()
In an adjacent cell all I want to do is pull the first 6 digits of the first number that starts with 630.
If there isn't any I want a blank cell.
Can anyone come up with a working formula, I'm stuck.