This content has been marked as final. Show 3 replies
1 of 1 people found this helpful
It's a guess without knowing all the "rules" in your data, but this should help:
if left(ID,4) = "pnrl"
You can use this formula:
REPLACE(REPLACE([ID], 'pnrl-',''), 'pnrl ', '')