Is Profit Center always a 6 digit number? If so, you could simply use LEFT() and then a string replace to get the remainder and split the string that way.
Alternatively, you could use the SPLIT function with a CONTAINS that determines if the string has a dash or not.
IF CONTAINS([Profit Center], '-') THEN SPLIT([Profit Center], '-', 1) ELSE SPLIT SPLIT([Profit Center], '-', 1) END
Hope this helps!
How would the full function look like using that? I basically just want to extract the text out of the string, so everything after the 6-digit profit centers.
Something like this maybe?
REPLACE([Profit Center], LEFT([Profit Center], 7), '')
Genius! Thanks Derrick!