College Data Help

Hello,

Is there a way to use a wildcard search or query on a data range, but the constant part not be at the beginning? For example, I want to find any number with a "14" in the 5-6th position in a 13 digit number (5305144222096).

Does anyone have an idea on how to do that?

Thank you,

ALW2675

Good afternoon,

I'm not sure about a query, but you could use a conditional format. Highlight the entire range and then use the conditional format option where you use your own formula. Then use:

=mid( --- top left cell, as a relative reference --- , 5 , 2 ) = "14"

and then set your format.

This won't query all of the data, but it will highlight favorable occurrences, then you can filter by color or whatever.

I'm sure there is a better way, but I would need to see your source data (or perhaps one of true guru's will wander by :smile.

Best of luck,

Took a while to wander but I think you are looking for "????14"
Look at http://office.microsoft.com/en-au/excel-help/wildcard-characters-HP005203612.aspx
and also possibly http://office.microsoft.com/en-au/excel-help/search-searchb-functions-HP010062577.aspx

Thanks, guys! Your responses were very helpful.