I've searched for the answer, but I keep getting the wrong wording.
I want to FIND records that have a blank space in a particular field, not replace anything.
I am importing records from an Excel file. The records are the results of registration using an online form. The form asks for the first and last names separately, but several times, parents have filled in the first name field with the full name and the last name field with the last name. (I don't know why they don't realize they did that after they type the last name again, but that's a whole other thing!)
What I would like to do is run a query that returns records where the first name has a space. I don't want to replace anything using the query because many times a legitimate first name has a space … Amanda Lynne or Mary Grace.
All I can find is references to replacing the space " " with nothing "".
Is there a way to do what I want?
Thanks!
Susie
Kansas