I am trying to rename some items to a smaller format to save report space in a table I am building.
I have a column with multiple values that have to much text I need to bring down.
Example, the column would contain
BMW Motorsports
Ferrari Motorsports
Mercedes Motorsports
I want them to display as
BMW
Ferrari
Mercedes
An example of my formula so far is
=If(Match([Competitor];"*BMW*");"BMW";0)
I would like to do something like this =If(Match([Competitor];"*BMW*");"BMW";0) Else If(Match([Competitor];"*Ferrari*");"Ferrari";0)
But this is not working, suggestions?