Formula to only show characters before a specific character in a cell?
Needing some help creating a helper column. In column from imported report I get, "Asphalt Distributor (45)" where the "45" represents the quantity of assets in that category. I need to create a helper column that extracts the "(45)" and shows only the "Asphalt Distributor".
Please note: there are many asset categories, which means the number of digits before the (#) will vary, and of course the # of assets in each category will vary (#), (##), or (###).
Examples: Asphalt Distributor (45), Dump Truck (104), Material Transfer Machine (8)
Probably an easy formula, just not a function I've needed before.
Thank you very much!