Trimming column rows where there is a dash

[bhanney2323]

Hey I was wondering if it is possible in a data table to trim column row values to the point where everything to the left of the dash is trimmed. 

So for example I may have a row like: "First - Blue Bike" and I just want to show Blue Bike

Additionally there are a couple of odd outliers in this dataset that may be tricky like one is similar to something like this: "First - Second - Red Bike" And I just want to show Red Bike

If anyone knows how I can use trim to solve this issue, it would be greatly appreciated. 

[Drrickryp · Accepted solution]

Hi @bhanney2323 

Last(Split("First - Second - Red Bike", " - ")).Result

ref: http://powerappsguide.com/blog/post/text---splitting-text-by-spaces