How can I force the removal of spaces on both sides of a dash/hyphen for an entire column in Excel? Ideally, I'd like any added value to be trimmed in this manner automatically. Having to apply a formula or similar to the column after the fact won't work. I am looking to auto correct (or as a secondary option, highlight) in real time.
Problem: Non technical users add values to a column in a data sheet and they are inconsistent with their spacing around dashes (where consistency is needed). Thanks.
Column 1
Car-SUV-Blue - 2020 will be Car-SUV-Blue-2020
Car -SUV-Blue- 2020 will be Car-SUV-Blue-2020