Search results

Thank you so much for all your responses. I'm going with vbaInet's code and will submit it. I liked it because it shows where the spaces are and the number is very visual and will help the person on the receiving end. I'll tweak a little, but I think this works fantastic. This database was...

Hello. Thank you so much for your advice. But it's not what I need. I don't need to replace or update or trim..this is for someone else who will do something (don't know what) with the query results. I just need to show the firstname, middleinitial, lastname of those who have leading, trailing...

Yes. Exactly. People can have two first names, 2 middle names, 2 last names...I know!

Hello, I need to write a query that tells me who has spaces before their names and after, and when there are two names in the field, who has more than one space. -The fields are Firstname, MiddleInitial, and LastName -The data for all of them can look like(using _for spaces): _Jim_Bob...