Pulling over data with specific criteria

[HNoel33]

I have an issue here.
I have a huge listed of assets - the column i where my info is has vasrious serial numbers.... some are a simple string of letters/numbers and the others look like this for example AG-1234567

I need to somehow pull out the ones that look like that. (AG-1234567). I only need those. Now normally i would just do a filter and pull em out however, this sheet contains 73k worth of items.

what would be the formula to perform such a task?

please help!

[Pete_UK]

I don't think a formula solution would be any quicker with 73k rows than manually applying a filter and then copying to another sheet, but this thread from yesterday shows how you can do it:

http://www.excelforum.com/excel-form...xed-value.html

Hope this helps.

Pete

[judgeh59]

can you upload the file....so, you want to return all rows that start with AG-*?....autofilter should work no matter how many rows....