Data Model - Formula not working

[michael8000]

I'm trying to pull out a specific word from my Data Model. I added a new column and this formula works in regular excel but not in the Data Model. Anyone have any ideas why its not working?

My goal is to have only single word "Adobe" on the type column (type column was just added)

 

[michael8000]

ohhhhhhhhhhhhhhhhhhhhhhhhh Citizenbh....you are a life saver!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

 

[michael8000]

thx for trying Sandy...but none of those worked.......I think the =1 was the part I needed to make the formula work that I was missing

 

[sandy666]

sure, but CONTAINSSTRING, as you could see, works well
anyway, I am glad this is solved for you
Have a nice day

 

[michael8000]

.

 

[citizenbh]

Even the latest Excel version 1911 does not support the CONTAINSSTRING function