Hi all. I apologize if this should be else where. I am using Excel 2007, but it might be the same across all versions.

I have a large excel sheet with a column containing the data below:

A
B
.
. .
Z

and

1
2
3
.
.
.
29

There are other columns associated to these and so the A-Z and 1-29 range repeats itself several times in one column.

Is there a way to tell excel to search a certain string (or range) on cells and have excel spit back, either by 1's and 0's or error messages, where a string is missing a number/letter in the link. So for example, the letter string is missing, say letter E? Or the number string is missing, say, # 6?

Thanks,
Ryan