So apparently, due to manual item additions, some items have been duplicated because there was a hanging space on the item name. I can't seem to figure out how to do a saved search that will bring up items that contain a space, it just brings up the entire item list when I do Name Contains and then a space for the value. Anyone have an idea how I could look that up?

Use a numeric formula condition. This finds the first occurrence of the " " (space). You could also add a case statement to this comparing it to the length - 1 to look for trailing spaces.

This might come in handy for me too. Thanks for the inspiration!