Column A has the following formats:
I need a formula in Column B that trims Column A after the first dash, so the results of the above rows would be:
I have been using the following formula to date, which worked as there was always just one dash in the text string, but now that there can be more than one dash, I am not getting the results I need:
I have attached a sample file. Column C shows the desired results.