Hi Thomas,
I am not clear whether you want to build a Company-Item ID-Business Area string or deconstruct it.
If you want to concatenate 3 columns together separarated by hyphens, use
CONCATENATE({Company},"-"{Item ID},"-",{Business Area})
If you want to extract the first part of Company-Item ID-Business Area
LEFT({Name},SEARCH("-",{Name})-1)
What if we could break free of the Formula column? and write formulas that update any type of columns? What if a formula could update multiple columns at once? This is possible with the Advanced Formula Booster app.