Bulk Edit - wildcard to find/remove blank space
I need to remove an unwanted space in a field for multiple records.
Example: TX- 12345678 => TX-12345678
A search using * for wildcard (select field, enter "*- *" shows several hundred records as desired.
But then when I want to do a bulk edit to remove the blank space, the field does not show up in the dropdown for bulk edit.
How can I remove an unwanted space in a specific field for multiple records at once?