I have a bunch of data in a column. The data can have dashes but never more that 2. Sometimes I get 3 dashes and need to remove the third dash along with everything after it. Is there a way for a piece of VBA code can check if the cell has 3 dashes and if does, remove the third dash along with everything after it? If the cell doesn't have 3 dashes do nothing. Then continue to the end of the data.
apple -> apple
pear-01 -> pear-01
peach-01-23 -> peach-01-23
banana-02A-3F-01 -> banana-02A-3F
Bookmarks