Remove TM from front of recipe

[jm22]

Hi there, 

I know how to get things off the end of a string but not the start!!! 

I have recipes that look like this 

Easy veggie, lentil and quinoa dahl with pita toasts (KIDS)
Greek salad with crispy chickpeas and potatoes
Miso eggplant with broccolini and edamame
TM Pan-fried salmon with creamy pumpkin millet
TM Moroccan spiced beef and lentils with carrot couscous

I want to create a field that has all the recipe names - but without the TM at the start. 

TIA

[TheTimeSavingCo · Accepted solution]

Assuming it's always going to be "TM", you could try:

IF(
  LEFT(Name, 3) = "TM ",
  REPLACE(Name, 0, 3, ""),
  Name
)

[jm22]

it worked!!