Skip to Content
0
Former Member
Jul 26, 2016 at 05:41 PM

String MATCH functions in one variable

2033 Views

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?