Thanks Ron, Dom answered my question.

"Ron Coderre" wrote:

You want to "pull records"?

How did you want to do that?
Using AutoFilter? Advanced Filter?
Did you want to use formulas to flag the items then sort and move?

***********
Regards,
Ron

XL2002, WinXP


"JH" wrote:

I need to pull records that have a blank space somewhere in the data , for
example "type 1" as opposed to "type1" or "help me" as opposed to "helpme".
Your help is much appreciated.